-
编辑 删除
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...
-
编辑 删除
Drop Baselines Hangs on Library Cache Lock (文档 ID 2186647.1)
In this DocumentSymptomsCauseSolutionReferencesApplies to:Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformatio...
-
编辑 删除
Hang with Library Cache Lock and Blocker is Internal Query SQL 8p7ujfdc5aycf
Database Hangs with 'Library Cache Lock' and the Blocker is Due Internal Query with SQL_ID '8p7ujfdc5aycf' (文档 ID 2192624.1)In this DocumentSymptomsChangesCause...
-
编辑 删除
High 'library cache lock' Wait Time Due to Invalid Login Attempts
High 'library cache lock' Wait Time Due to Invalid Login Attempts (文档 ID 1309738.1)In this DocumentSymptoms Mutex Sleep SummaryChangesCause...
-
编辑 删除
Script toCollect Log File Sync Diagnostic Information (lfsdiag.sql)
Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql) (文档 ID 1064487.1)In this DocumentPurposeRequirementsConfiguringInstructions...
-
编辑 删除
Adaptive Log File Sync Optimization (文档 ID 1541136.1)
In this DocumentGoalSolution 'log file sync' Waits Parameter: _use_adaptive_log_file_sync Known Issue...
-
编辑 删除
Script to Collect Data Guard Physical and Active Standby Diagnostic Information
Script to Collect Data Guard Physical and Active Standby Diagnostic Information for Version 10g and above (Including RAC) (文档 ID 1577406.1)Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.Main Content**...
-
编辑 删除
Script to Collect Data Guard Primary Site Diagnostic Information
Script to Collect Data Guard Primary Site Diagnostic Information for Version 10g and Above (Including RAC). (文档 ID 1577401.1)Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]Information in this document applies to any platform.Main Cont...
-
编辑 删除
12c 的 Cascaded Standby 数据库 (文档 ID 2179701.1)
文档内容用途详细信息 实时 Cascading： 先决条件： 设置： Fa...
