Oracle

1. EnvironmentVMware Ten centos-6.3-x86_64Oracle:linux.x64_11gR2Hardware I divided 2.5G of memory, 30G HDD (should not need so large) 2 U2.2.1 Install the system first, after the root login need to change the system settings:Setup command to turn

First describe the version of the databaseServer: 10.2.0.5.0Client: 11.2.0.1.0Export will errorEXP-00008: Encountering ORACLE error 1003Ora-01003:no statement parsedAndEXP-00008: Encountering ORACLE error 904ORA-00904: "MAXSIZE": Invalid

Overview of basic methods for Oracle performance optimization1) Set up a reasonable performance optimization target. 2) measure and record current performance. 3) Determine the current Oracle performance bottleneck (what Oracle waits for and what

Package Cn.liz.test;import Java.io.inputstream;import Java.sql.connection;import java.sql.driver;import Java.sql.sqlexception;import Java.util.properties;import Org.junit.test;public class JBDCtest {/** * Write a common method, You can obtain a

After upgrading the DB cluster to 10.2.0.5, the two-node server restarts continuously, querying the Oracle OPROCD process log for the following information:Jul 03 08:16:34.702 | INF | Monitoring started with timeout (+), margin ($), Skewtimeout (03)

List the points of knowledge about OPROCDOPROCD is the introduction of Oracle in RAC to fencing IOUnder UNIX systems, there is a OPROCD process if we do not use third-party cluster software other than OracleUnder the Linux system, the OPROCD process

Log in to the database with Conn/as sysdba.First: Create a new userCreate User by test02 (test01 for user name, test02 for user password)Second: Give basic permissions to database operationsGrant to test01;Three: Create a table spaceCreate the

The System (Oracle+weblogic) released in the previous period frequently hangs, every morning 9 points, 2 o'clock in the afternoon peak on the hanging, tangled for a long time, the final Solution, method description under.Executes select COUNT (*),

1 --View table Space capacity2 SELECT UPPER(f.tablespace_name) "tablespace name",3 D.TOT_GROOTTE_MB "Table space size (M)",4D.tot_grootte_mb-f.total_bytes "used Space (M)",5To_char (ROUND((D.TOT_GROOTTE_MB-F.total_bytes)/D.tot_grootte_mb* -,2),'990.

ORACLE SQL TraceAUTOTRACE command1 SET AUTOTRACE off this is the default value, which is to turn off AUTOTRACE2 set AUTOTRACE on produces a result set and interprets the plan and lists the statistics3 Set AUTOTRACE on EXPLAIN display result set and

1. Error descriptionORA-12801: Error signal ORA-01722 in parallel query server P007: Invalid number 12801.00000-"error signaled in parallel query server%s" *cause:a parallel qu Ery server reached an exception Condition.*action:check the following

1. Wait for the monitor case Select Event,sum (Decode (wait_time,0,0,1)) "Prev", Sum (Decode (wait_time,0,1,0)) "Curr", COUNT (*) "Tot" From V$session_wait Group BY event order by 4;Note: ORDER by 4 refers to sort by 4th column2. Race Conditions

 Oracle 10g RAC Start-Stop archive modeIf the Oracle database is running in archive mode, you may need to pause the archive of the database when you perform database maintenance, and then restart the archive mode after maintenance is complete.You

Today upgrade a 10g cluster environment to 10.2.0.5, download the patch package P8202632_10205_linux-x86-64.zip online, after decompression installation execution, midway error:I/O ERROR cannt reading or opening file in/tmp/...../temp52The online

Oracle Database lab handouts-Reading Notes (1), oracle Handouts 1. Activate the Locked UserAlter user scott account unlock identified by tiger;2. Use the embedded script to create a scott user@ % Oracle_home % \ rdbms \ admin \ utlsampl. SQL3. view

Let's talk about the ORACLECPROCD process. List knowledge points about oprocd Oprocd is introduced by oracle in rac for fencing io In unix systems, if we do not use third-party cluster software other than oracle, The oprocd process will exist. In

1. If you have a plsql client, you can use this user to log on and right-click all tables and Drop them.2. If you have the permission to delete a user, you can: Drop user user_name cascade; With cascade, you can delete all associated user data.

This error is often returned when an Oracle database is shut down illegally: EXP-00056: ORACLE error 1033 ORA-01033: ORACLE initialization or shutdown in progress User: password: This is obviously because the database cannot be started, but the

Background:On the local machine (Win7 64-bit flagship Edition) Install the Oracle 11g Client32-bit ORACLE clientIf the 64-bit ORACLE client is installed, you cannot enter the sqlplus/nolog command in the CMD command, that is, the command cannot be

Stealing: http://www.blogjava.net/hello-yun/archive/2011/04/08/347890.html Table TESTA, TESTB, and TESTC have two columns, A and B: TESTA (A, B) | TESTB (A, B) | TESTC (A, B) 001 10A | 001 10B | 001 10C 002 20A | 003 30B | 004 30C   There are two