WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! 與 dc_tablespces
WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!
dc_tablespaces
Probably the most likely cause is the allocation of new extents. If extent sizes are set low then the application may constantly be requesting new extents and causing contention. Do you have objects with small extent sizes that are rapidly growing? (You may be able to spot these by looking for objects with large numbers of extents). Check the trace for insert/update activity, check the objects inserted into for number of extents.
遇到過這樣表空間自動擴充套件這樣的一個案例，建議改為手動擴充套件，並且表空間在規劃時建立為assm模式,採用uniform size 統一大小的模式。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-1181984/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!AIENQ
- 故障排除："WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! "AIENQ
- WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!的分析AIENQ
- 一次WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCKAIENQ
- Metlink:Troubleshooting:WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!AIENQ
- WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK-[ID 278316.1]AIENQ
- 翻譯metalink關於WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK文章AIENQ
- 通過system state dump分析WAITED TOO LONG FOR A ROW CACHE ENQUEUEAIENQ
- 等待事件之Row Cache Lock事件
- ORA-00494 enqueue [CF] held for too long故障分析處理ENQ
- 【ASK_ORACLE】Row Cache Enqueue鎖之概念篇OracleENQ
- ORA-00494: enqueue [CF] held for too long (more than 900 seconds)ENQ
- hanganalyze解決row cache lock(ZT)
- [ORACLE 11G]ROW CACHE LOCK 等待Oracle
- ORA-00494: enqueue [CF] held for too long (more than 900 seconds) -RACENQ
- 轉）用hanganalyze解決row cache lock
- （轉）用hanganalyze解決row cache lock
- 轉貼_用hanganalyze解決row cache lock
- 用hanganalyze解決row cache lock（轉貼）
- oracle enqueue lockOracleENQ
- WAITEVENT: "row cache lock" Reference Note (文件 ID 34609.1)AI
- 由row cache lock等待事件引起的效能問題事件
- 【MySQL】select for update 的Row Lock 與Table LockMySql
- Resolving Issues Where 'Row Cache Lock' Waits are OccurringAI
- 一次Row Cache Lock問題處理過程
- Rac 環境中分割槽表建立index hang(row cache lock)Index
- How to Match a Row Cache Object Child Latch to its Row CacheObject
- hang了,嚴重的row cache lock 等待事件--就因大sql文字事件SQL
- ORA-01704: string literal too long 與CLOB
- enable table lock 的enqueue等待ENQ
- Metlink:How to Match a Row Cache Object Child Latch to its Row CacheObject
- 記一次row cache lock引起的效能問題分析處理
- sqlserver kill long time lockSQLServer
- 當刪除oracle資料庫user時發生row cache lock 等待事件Oracle資料庫事件
- oracle??邏輯DG同步卡住,session等待row cache lock的處理過程OracleSession
- 11G 修改使用者密碼導致的row cache lock密碼
- mysql specified key was too long與Index column size too large. The maximum column size is 767 bytes.MySqlIndex
- row cache objects latch研究Object