Oracle

The construction of enterprise information systems can be divided into IT planning, IT construction, and it o & M phases based on the lifecycle. The it o & M phase takes the longest time, it o & M management is related to the quality, cost, and

In the Oracle database, the SOUNDEX function returns the voice representation of the string parameter, which is useful for spelling different words, but has the same pronunciation as some others. Syntax of the SOUNDEX function: SOUNDEX (string)

Similar to the installation of Oracle12c, I have done this tutorial to communicate with colleagues. The tutorial content includes:1. Detailed installation manual, 60-page Word Document2. Detailed installation script to simplify installation

The customer database server encountered a strange phenomenon during the training process. The customer's database server environment is AIX6 + Oracle11gR2. The specific phenomena are as follows: When executing EXP export, some tables prompt EXP-0001

Symptom: The application's night dimension starts to run at, but for hang reasons (it is assumed that a piece of data processed by the night dimension is the same as that processed by the current application, wait for the same resource lock until

In the CBO mode, the optimizer determines whether to use full table scan or index. The optimizer compares all possible methods and selects the lowest cost method. Using SQL Tuning Advisor and SQL Access Advisor, you can call the optimizer in

How to query the average Message Size sent by an instance in rac Run the following command to obtain the average Message Size sent by an instance in rac: SQL> select sum (kjxmsize * (kjxmrcv + kjxmsnt + kjxmqsnt)/sum (kjxmrcv + kjxmsnt + kjxmqsnt )

The installation of the oracle client is very simple. The key lies in the tns configuration. The rpm installation package I used here is that oracle itself is not open source, which is the easiest to install with rpm. 1. to remotely use oracle,

Weeks are calculated using the IW method. If there are more than or equal to four days between 52nd weeks in a year and December 31 days in that year, it is set to 53rd weeks in that year, otherwise, the remaining days are classified as the 1st week

1. ORACLE has two ways to authenticate sysdba/sysoper users: 1). Operating System Level Authentication: After logging on to the oracle Database Host, you can use sqlplus/as sysdba to log on directly: users who belong to the dba permission group

Solutions for EXP-00008 & ORA-06550 & ORA-00904 during expSymptom: exp returns an error as follows:[Oracle @ cicgo1 oracle] $ exp system/pass owner = cicgo file =/tmp/cicgo. dmpExport: Release 8.1.7.4.0-Production on Tue Apr 23 15:07:17 2013(C)

1. Create a database mybase in oracle and a new users table. The table has two fields: id: auto-increment and name. The steps are omitted. 2. Create a java project and import two jar packages: classes12.jar and mybatis-3.0.4.jar. 3. Create a package

Oracle ORA-12514 SolutionWhen Oracle uses exp to export table data, a ORA-12514 occurs and the findings share error: ORA-12514: TNS: The Listener currently cannot identify the service reason requested in the connection descriptor: SID configuration

scott.pro_para_inout(p_dname out scott.dept.dname p_loc out scott.dept.locTYPE) dbms_output.put_line(p_dname dbms_output.put_line(p_loc pro_para_inout; Call ;   Result When the parameter type

I wish you all the best in 14 years. Show the date and the week of the day:SQL> select to_char (sysdate + level-1, 'yyyy-mm-dd') dt,To_char (sysdate + level-1, 'aws') weeks from dual connect by level DT WE------------2014-01-03 012014-01-04 012014-01

The first thing we think of is creating an index. Creating an index can multiply the query efficiency and save time. However, if the data volume is too large, simply creating an index at this time will not help. We know that if we count queries in

1. Memory Management, add at the end of the file/Etc/sysctl. conf fs. aio-max-nr = 1048576 fs. file-max = 6815744 kernel. shmall = 2097152 kernel. shmmax = 536870912 kernel. shmmni = 4096 kernel. sem = 250 32000 100 128 net. ipv4.ip _

I personally understand that the most important factor in database performance is I/O, because the operation memory is fast, but the read/write speed is very slow. The most critical problem in optimizing the database is to reduce the disk I/O, the

When PL/SQL is compiled, the following error occurs: ora -- 00911, incalid character. This error is caused by a problem with the SQL statement and is not identified during SQL check. However, you should note that this error is often caused by the

Select distinct --, -- from --; // query the specified row, which is not repeated.Set timing on; // display the start timeSelect count (*) from --; // countSelect -- ''-- from --; // alias of the name displayedNvl (comm, 0) // If comm is not empty,