buffer busy waits, latch cache buffers chains, read by other session區別
latch :cache buffers chains 是block header lacth 的競爭
buffer busy waits 和read by other session 是 buffer block 的競爭
(10g以後read by other session從buffer busy waits獨立出來)
參考http://www.itpub.net/thread-1801066-1-1.html
Oracle 訪問資料塊的大概步驟:
1)
依據資料塊的地址計算出資料塊所在的bucket
2)獲得保護這個bucket的cbc latch-- latch :cache buffers
chains
3)在這個連結串列上找尋我們需要的資料塊,找到後,pin這個buffer(讀取s,修改x)--- buffer busy waits
4)釋放cbc latch
5)讀取/修改資料塊的內容
6)獲取cbc latch
7)unpin這個buffer
8)釋放cbc latch
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15747463/viewspace-776129/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Buffer busy waits/read by other sessionAISession
- 等待事件_buffer_busy_waits_and_read_by_other_session(1)事件AISession
- 等待事件_buffer_busy_waits_and_read_by_other_session(2)事件AISession
- 等待事件_buffer_busy_waits_and_read_by_other_session(3)事件AISession
- 等待事件_buffer_busy_waits_and_read_by_other_session(4)事件AISession
- buffer cache實驗6-latch:cache buffers lru chainsAI
- latch: cache buffers chainsAI
- latch:cache buffers chains案例AI
- Latch: cache buffer chains (%)AI
- 深入理解latch: cache buffers chainsAI
- Trouble shooting latch: cache buffers chainsAI
- ORACLE等待事件latch: cache buffers chainsOracle事件AI
- 等待事件_cache_buffers_chains_latch事件AI
- latch:cache buffers chains解決步驟AI
- latch:cache buffers chains的優化思路AI優化
- cache buffers chains and cache buffers lru chainsAI
- cbc latch或cache buffer chains latch系列一AI
- Buffer Cache以及buffer busy waits/gc相關事件AIGC事件
- buffer cache實驗5-latch:cache buffers chainAI
- latch:cache buffers chains的最佳化思路AI
- latch: cache buffers chains---AWR實戰分析AI
- buffer cache實驗7-buffer busy waits-完成AI
- latch: cache buffers chains故障處理總結(轉載)AI
- 解決一例latch:cache buffers chains小記AI
- cache buffers chains vs cache buffers lru chainAI
- Oracle Buffer Busy WaitsOracleAI
- 一次latch cache buffers chains問題的處理AI
- 處理 latch_cache_buffers_chains等待事件一例AI事件
- 【等待事件】buffer busy waits事件AI
- CACHE BUFFER CHAINSAI
- cache buffers LRU chain latchAI
- latch free(cache buffers chain)AI
- Buffer Busy Waits深入分析AI
- 客戶資料庫出現大量cache buffer chains latch資料庫AI
- latch: cache buffers chains-熱塊的簡單模擬實驗AI
- Oracle Cache Buffer ChainsOracleAI
- 用於排查cache buffers chainsAI
- Cache Buffers chains,存在共享模式?AI模式