How to recreate the SYS.ALERT_QUE [ID 430146.1]
In this Document Goal Solution ReferencesApplies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2Information in this docum...
How to Find which Session is Holding a Particular Library Cache Lock
ID 122793.1Applies to: Oracle Server - Enterprise EditionOracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.3 [Release: 9.2 to 11.2]Oracle Server - Personal E...
How to Dump Redo Log File Information [ID 1031381.6]
***Checked for relevance on 18-Jan-2012***PURPOSEThis article explain how to obtain a dump of the header information in the online redo log file(s), as well as obtaining selected information from...
ORA-4031 in Large Pool Executing DBMS_METADATA.GET_DDL By Shared Server Conn
ID 1271785.1In this Document Symptoms Cause Solution ReferencesApplies to:Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.3...
High 'cursor: pin S wait on X' and/or 'library cache lock' Waits.
ID 742599.1In this Document Symptoms Changes Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0....
ORA-04030 When Clients Connect Across Network Using SQL*Net [ID 753439.1]
In this Document Symptoms Changes Cause Solution ReferencesApplies to:Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.2.0.2 - Releas...
PLSQL Procedure Causing ORA-04030
[ID 1325100.1]In this Document Symptoms Changes Cause Solution ReferencesApplies to:Oracle Server - Enterprise Edition - Version: 11.2.0.1 ...
ORA-600 [kgmgchd1] and ORA-4031 While Running Select Statement [ID 1224393.1]
In this Document Symptoms Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5 and later [R...
How to investigate ORA-04031 error if limited diagnostics are provided in 11g?
修改时间:2010-11-4类型:HOWTO状态:PUBLISHED优先级:3 In this Document Goal SolutionApplies to: Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later  ...
11.2.0.3.0 (Redhat Linux X86-64) ORA-00600 : [ktbesc_plugged], [], [], ...错误
这个错误目前在metalink上还没有找到相同的case看trace文件是在一个Trigger的Insert语句时报错这个库之前历经10.2.0.4.0/11.2.0.1.0/11.2.0.3.0 Linux X86三个版本都没报ORA-00600,唯独换成Linux X86-64后Trigg...
ORA-4030 PGA Usage Diagnostic Script [Video] [ID 1087789.1]
修改时间 07-DEC-2011 类型 SAMPLE CODE 状态 PUBLISHED In this Document Purpose Software Req...
Master Note for Troubleshooting Oracle Managed Distributed Transactions
[ID 100664.1]修改时间 11-SEP-2011 类型 ANNOUNCEMENT 状态 PUBLISHED In this Document What is bein...
Diagnosing and Resolving ORA-4030 errors [ID 233869.1]
Applies to:Oracle Server - Enterprise Edition - Version: 8.1.7.4 and later [Release: and later ]Information in this document applies to any platform.PurposeHow to diagnose ORA-40...
How To deal with INITTRANS/MAXTRANS ORA-00060 / Deadlocks [ID 164661.1]
PURPOSE-------This article explains the most common scenarios for Deadlocks and howto avoid them. SCOPE & APPLICATION-------------------This article is intended for Oracle ...