ORA-4030 PGA Usage Diagnostic Script [Video] [ID 1087789.1]
修改时间 07-DEC-2011 类型 SAMPLE CODE 状态 PUBLISHED In this Document Purpose Software Req...
How To Resolve Stranded DBA_2PC_PENDING Entries [ID 401302.1]
修改时间 21-NOV-2011 类型 BULLETIN 状态 PUBLISHED Applies to:Oracle Server - Enterprise Edition - Version:...
ORA-19527 reported in Standby Database when starting Managed Recovery
[ID 352879.1]修改时间 28-MAR-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Ca...
Fatal NI Connect Error 12170, 'TNS-12535 Reported in 11g Alert Log
[ID 1286376.1]修改时间 14-NOV-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms &...
Master Note for Troubleshooting Oracle Managed Distributed Transactions
[ID 100664.1]修改时间 11-SEP-2011 类型 ANNOUNCEMENT 状态 PUBLISHED In this Document What is bein...
Alert Log Messages: Private Strand Flush Not Complete [ID 372557.1]
In this Document Symptoms Changes Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0...
The Performance Impact of Deadlock Detection [ID 285270.1]
Checked for relevance 8-18-2010.PURPOSE-------To increase awareness of the performance impact that deadlock detection can have on an instance. SCOPE & APPLICATION-------------------This a...
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...
Howto set maximum user processes on AIX [ID 1084995.1]
修改时间 26-AUG-2010 类型 HOWTO 状态 PUBLISHED In this Document Goal SolutionApplies...
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 ...
Troubleshooting: High Version Count Issues [ID 296377.1]
Troubleshooting: High Version Count Issues [ID 296377.1] 修改时间 03-NOV-2011 类型 TROUBLESHOOTING 状态 PUBLISHED In...
Troubleshooting 'library cache: mutex X' waits. [ID 1357946.1]
修改时间 22-SEP-2011 类型 TROUBLESHOOTING 状态 PUBLISHED In this Document Purpose La...
How To Identify a Hot Block Within The Database Buffer Cache. [ID 163424.1]
修改时间 16-OCT-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution &...
Fundamentals of the Large Pool [ID 62140.1]
修改时间 24-JUN-2009 类型 BULLETIN 状态 PUBLISHED Introduction~~~~~~~~~~~~ This short article describ...
VIEW: X$KSMLRU - LRU flushes from the shared pool - (7.3 - 8.1) [ID 43600.1]
修改时间 04-NOV-2011 类型 REFERENCE 状态 ARCHIVED Note to customers:~~~~~~~~~~~~~~~~~~ This is an Orac...
Tuning the Shared Pool and Tuning Library Cache Latch Contention
[ID 62143.1]修改时间 04-NOV-2011 类型 TROUBLESHOOTING 状态 PUBLISHED In this Document Pur...
Troubleshooting: "WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! "
[ID 278316.1]修改时间 16-OCT-2011 类型 TROUBLESHOOTING 状态 PUBLISHED In this Document Pu...
How To: Diagnose HANG with PMON failed to acquire latch, see PMON dump
[ID 976714.1]修改时间 16-OCT-2011 类型 HOWTO 状态 MODERATED In this Document Goal &n...
一卡通數據庫 物化視圖優化
本帖最后由 spider0283 于 2011-11-3 17:31 编辑我們的一卡通庫 1號升級後,一個物化視圖log漲到16.8G,1號凌晨遠端物化視圖刷新時,因為要刪本機的物化視圖log,而造成ORA-01555錯誤,UNDO段撐到32G。仔細研究了一...
Fatal NI connect error 12170', 'TNS-12535: Reported in 11g Alert Log
[ID 1286376.1]修改时间 19-OCT-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes&nbs...