cache buffers LRU chain latch
This latch is needed when user processes try to scan the LRU (least recently used) chain containing blocks in the buffer cache. This latch must be acquired before the block can be inserted into (when the block is read in from the disk) or taken out of the LRU chain (when the block is written down to the disk).
Solutions:
1)Consider implementing multiple buffer pools to reduce contention on this latch.
2)Increase the number of LRU latches with the parameter DB_BLOCK_LRU_LATCHES. Generally the default value works.
3)Reduce data blocks visited by a query and thereby reduce LRU latch requests in the buffer pool by tuning the SQL.
cache buffers lru chain latch爭用主要由於過多空閒緩衝區請求導致,如下情況可能導致該latch競爭:
1)低效SQL
2)過小的buffer cache
3)過多的檢查點
cache buffers chains latch與cache buffers lru chain latch區別:
1)前者在多個會話同時訪問同一個表或索引,甚至集中在某個熱塊時發生,後者發生在多個會話分別訪問不同表導致空閒緩衝區爭用而引發
2)後者一般伴隨物理IO(索引掃描時db file sequential read,全表掃描時db file scattered read)
參考:等待事件_cache_buffers_lru_chain_latch
http://blog.itpub.net/18922393/viewspace-712721/
Solutions:
1)Consider implementing multiple buffer pools to reduce contention on this latch.
2)Increase the number of LRU latches with the parameter DB_BLOCK_LRU_LATCHES. Generally the default value works.
3)Reduce data blocks visited by a query and thereby reduce LRU latch requests in the buffer pool by tuning the SQL.
cache buffers lru chain latch爭用主要由於過多空閒緩衝區請求導致,如下情況可能導致該latch競爭:
1)低效SQL
2)過小的buffer cache
3)過多的檢查點
cache buffers chains latch與cache buffers lru chain latch區別:
1)前者在多個會話同時訪問同一個表或索引,甚至集中在某個熱塊時發生,後者發生在多個會話分別訪問不同表導致空閒緩衝區爭用而引發
2)後者一般伴隨物理IO(索引掃描時db file sequential read,全表掃描時db file scattered read)
參考:等待事件_cache_buffers_lru_chain_latch
http://blog.itpub.net/18922393/viewspace-712721/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31397003/viewspace-2150823/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 等待事件_cache_buffers_lru_chain_latch事件AI
- cache buffers lru chainAI
- latch free(cache buffers chain)AI
- cache buffers chains vs cache buffers lru chainAI
- cache buffer lru chain latch等待事件AI事件
- buffer cache實驗5-latch:cache buffers chainAI
- buffer cache實驗6-latch:cache buffers lru chainsAI
- cache buffers chains and cache buffers lru chainsAI
- latch: cache buffers chainsAI
- oracle實驗記錄(buffer_cache分析(3)cbc lru chain latch)OracleAI
- latch:cache buffers chains案例AI
- Cache Buffer Chain Latch等待事件AI事件
- cr塊和latch buffer cache chainAI
- cache buffer chain latch只讀共享?AI
- 深入理解latch: cache buffers chainsAI
- Trouble shooting latch: cache buffers chainsAI
- ORACLE等待事件latch: cache buffers chainsOracle事件AI
- 等待事件_cache_buffers_chains_latch事件AI
- latch free 中 cache buffer chain 的整理AI
- latch:cache buffers chains解決步驟AI
- latch:cache buffers chains的優化思路AI優化
- latch:cache buffers chains的最佳化思路AI
- latch: cache buffers chains---AWR實戰分析AI
- cache buffer chain latch可以以只讀模式共享AI模式
- latch: cache buffers chains故障處理總結(轉載)AI
- 解決一例latch:cache buffers chains小記AI
- 一次latch cache buffers chains問題的處理AI
- 處理 latch_cache_buffers_chains等待事件一例AI事件
- buffer busy waits, latch cache buffers chains, read by other session區別AISession
- latch: cache buffers chains-熱塊的簡單模擬實驗AI
- cache buffer chainAI
- Bug 3797171 cache buffers chains latch contention increased in 10g-3797171.8AI
- 關於cache_buffer_lru_chain的疑問,知道的給小弟解答一下。AI
- Leetcode LRU CacheLeetCode
- [LeetCode] LRU CacheLeetCode
- buffer cache部分原理(LRU)
- 等待模擬-cache buffer chainAI
- Latch: cache buffer chains (%)AI