Oracle

When oracle was installed, the machine name was host = user49561.After modification, start the oracletnslisener service in the control panel service and immediately stopUse the command line tool instead:LSNRCTLStartTip: Tnslsnr for 32-bit windows:

Generally, it is only used as a client to access Oracle and does not need to install a large Oracle database. Sometimes I often forget how to configure the lite version of oracle.ArticleBack up a record. You can download the client suitable for

String ID to be deleted: String sdsales_idstring = 1, 2, 3, 4, 5, 6, 7 // Convert to array Array array = sdsales_idstring.split (New String [] {","}, stringsplitoptions. removeemptyentries). toarray (); Define a public array sdsales_ids {Get;

The dbverify tool is used to verify the physical structure of the data file.     The main purpose of the dbverify tool is to check the physical structure of the data file, including whether the data file is damaged, whether there are logical Bad

List all configured Databases [Root @ node1 ~] # Srvctl config DatabaseNovadb Status of all instances and services [Root @ node1 ~] # Srvctl status database-D novadbInstance novadb1 is running on node node1Instance novadb2 is running on node

There is a question about the datetime data type in the 1z0-007 question bank:Which three are datetime data types that can be used when specifying column definitions? (Choose Three) A. TimestampB. interval month to dayC. interval day to secondD.

The view v $ session_wait can be used to view the current wait events of the system and the information about the resources corresponding to the wait events, so as to determine the type of the bottleneck and its objects. The P1, P2, and P3 values of

1) create a package firstCreate or replace package apps. crackpwd authid CURRENT_USERAsFunction getpwd (orauser in varchar2, appuserpwd in varchar2)Return varchar2;End crackpwd;/Create or replace package body apps. crackpwdAsFunction getpwd (orauser

If reproduced, please indicate the source: http://blog.csdn.net/robinson_0612/archive/2009/10/04/4632312.aspx   1. Install Vmware I chose vmware6.5.2 workstation Green Edition + WINXP pro En + SP3 + RHEL 5.4, decompress VMware to the relevant

1. Partition the diskFdisk-l view disk statusFdisk/dev/SDB partitioning 2. Configure bare devices (modify the/etc/udev/rules. d/60-raw.rules file)In redhat51) Load bare DevicesAction = "add", kernel = "/dev/sdb1", run + = "/bin/raw/dev/raw/raw1%

 Note: This example is transferred from the DBA diary of the old white.   Just as I sat down, the phone rang. A customer called me and said it was a strange problem. In a large table with tens of millions of records, select * from where rownum   --

  For DBAs, these two commands are no stranger. You can use these two commands to collect table statistics. This article mainly looks at the differences between the two commands.   For more information, see: Oracle analyze command

  For a detailed description of the Shared Pool in Oracle SGA, refer to my blog: Oracle Shared Pool details Http://blog.csdn.net/tianlesoftware/article/details/6560956   In the previous blog, I introduced the composition and Principles of the Shared

There are two main causes:1. There is a large volume of transactions that allow Oracle undo to automatically expand, resulting in excessive disk space occupation;2. There are large transactions that have not been contracted or are not committed by

  Today, I took a look at Oracle 11.2.0.2 patch, patch number: 10098816. The maximum patch size is 6 GB. In the cup.         Oracle software is growing. These patch files are still running. After the patch files are finished, you can perform the

Oracle package purity level Pragma restrict_references (). This pragma is complex. In general, it is a program-assisted Validation Code that checks the purity of a subroutine and helps check whether it violates rules. It is generally used in

Error ----------- Connectionstring:Provider = oraoledb. Oracle; Data Source = ORACLE; user id = sinodigital; Password = AAAAA;------------ Err. Description:Provider cannot be found. It may not be properly installed.-----------

In this article, the server environment is win2008r2 64bit. The Oracle client used belongs to the developer edition, which is only 53 MB and has no UI operation interface. The installation is manual; Applicable to the formal running environment; :

There are still some omissions. The experiment is not very rigorous in theory! 1. transaction isolation level settings Oracle has two transaction isolation levels: connection. transaction_read_committed (Read committed) and connection.

For beginners, Oracle's database language PL/SQL is always a bit strange. It is called a host language and, as its name suggests, it is dependent on something to survive, PL/SQL is attached to the Oracle database, and its runtime environment is the