How to Match a Row Cache Object Child Latch to its Row Cache
How to Match a Row Cache Object Child Latch to its Row Cache (Doc ID 468334.1)Applies to:Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterInformation in this document applies to any platform.GoalStarting with Oracle 9.2, the 'row cache objects' latch has multiple c...
WAITEVENT: "latch: row cache objects" Reference Note (Doc ID 1550722.1)
latch: row cache objects" Reference NoteThis is a reference note for the wait event "latch: row cache objects" which includes the following subsections:Brief definition Individual wait details (eg: For waits seen in <<View:V$SESSION_WAIT>>) Systemwide wait details (eg: For w...
Resolving Issues Where 'Row Cache Lock' Waits are Occurring
Resolving Issues Where 'Row Cache Lock' Waits are Occurring (文档 ID 1476670.1)Applies to:Oracle Database - Standard Edition - Version 10.2.0.1 and laterOracle Database - Enterprise Edition - Version 10.2.0.1 and laterOracle Database - Personal Edition - Version 10.2.0.1 and laterInforma...
WAITEVENT: "row cache lock" Reference Note (文档 ID 34609.1)
row cache lock Reference NoteThis is a reference note for the wait event "row cache lock" which includes the following subsections:Brief definition Individual wait details (eg: For waits seen in V$SESSION_WAIT) Systemwide wait details (eg: For waits seen in V$SYSTEM_EVENT) ...
DataPump Export/Import Of LOBs Are Not Executed in Parallel
DataPump Export/Import Of LOBs Are Not Executed in Parallel (文档 ID 1467662.1)Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.2 [Release 10.2 to 12.1]Information in this document applies to any platform.***Checked for relevance on 09-DEC-2014*** SymptomsY...
How To Move DB To Different Diskgroup/Change Diskgroup Redundancy
How To Move The Database To Different Diskgroup (Change Diskgroup Redundancy) (文档 ID 438580.1)Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to 12.1]Or...
Oracle DB OS Install and Configure Requirements Quick Reference (8.0.5 to 11.2)
Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) (文档 ID 169706.1)Jump to: For 12c requirements refer to Note 1587357.1 AIX HP-UX (PA-RISC and Itanium) Linux x86 Linux x...
Oracle DB OS Install and Configure Requirements Quick Reference (12.1)
Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Solaris and MS Windows Operating Systems Installation and Configuration Requirements Quick Reference (12.1) (文档 ID 1587357.1)In this DocumentPurposeScope...
In V$SESSION, column SQL_ID is not NULL while STATUS is INACTIVE
In V$SESSION, column SQL_ID is not NULL while STATUS is INACTIVE (文档 ID 1923905.1)Applies to:Oracle Database - Standard Edition - Version 11.1.0.7 and laterOracle Database - Enterprise Edition - Version 11.1.0.7 and laterInformation in this document applies to any platform.Symptoms&...
SQL: How to Find Sessions Generating Lots of Redo or Archive logs
SQL: How to Find Sessions Generating Lots of Redo or Archive logs (文档 ID 167492.1)**Checked for relevance on 13-Oct-2015***goal: How to find sessions generating lots of redofact: Oracle Server - Enterprise Edition 8fact: Oracle Server - Enterprise Edition 9fact: ...
How to Identify Hard Parse Failures (文档 ID 1353015.1)
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.2 and laterInformation in this document applies to any platform.GoalHard parse time may be impacted when there are a high number of parse errors.This may be noted in the ADDM report as follows:FINDING 2: 62% impact (...
How To Find The Object That Causing ORA-600 [kqlnrc_1] (文档 ID 1190673.1)
How To Find The Object That Causing ORA-600 [kqlnrc_1] (文档 ID 1190673.1)Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterInformation in this document applies to any platform.***Checked for relevance on 22-Feb-2016***GoalHow to find the object that are c...