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...
Configuration of Load Balancing and Transparent Application Failover
Configuration of Load Balancing and Transparent Application Failover [ID 226880.1] 修改时间 14-JUL-2011 类型 BULLETIN  ...
How to Enable Oracle SQLNET Tracing from Net Manager
[ID 395525.1]修改时间 30-SEP-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal &n...
10g & 11g :Configuration of TAF and Load Balancing
[ID 453293.1]修改时间 27-SEP-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal &n...
Load Balancing Advisory and Connection Load Balancing [ID 552609.1]
修改时间 29-DEC-2010 类型 HOWTO 状态 PUBLISHED In this Document Goal SolutionApplies...
How to Identify Which Latch is Associated with a "latch free" wait
[ID 413942.1]修改时间 22-MAR-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal So...
WAITEVENT: "library cache pin" Reference Note [ID 34579.1]
修改时间 17-SEP-2011 类型 REFERENCE 状态 PUBLISHED "library cache pin" Reference NoteThis is a reference n...
Troubleshooting 'latch: cache buffers chains' Wait Contention [ID 1342917.1]
修改时间 03-AUG-2011 类型 TROUBLESHOOTING 状态 PUBLISHED In this Document Purpose La...
How To Identify a Hot Block Within The Database Buffer Cache. [ID 163424.1]
修改时间 12-OCT-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution &...
Tuning the Redolog Buffer Cache and Resolving Redo Latch Contention
[ID 147471.1]修改时间 14-SEP-2011 类型 BULLETIN 状态 PUBLISHED Purpose: This article prov...