gc buffer busy
gc buffer busy
This wait event, also known as global cache buffer busy prior to Oracle 10g,
specifies the time the remote instance locally spends accessing the requested data block.
This wait event is very similar to the buffer busy waits wait event in asingle-instance database and are often the result of:
1. Hot Blocks -
multiple sessions may be requesting a block that is either not in buffer cache or is in an incompatible mode.
Deleting some of the hot rows and re-inserting them back into the table may alleviate the problem.
Most of the time the rows will be placed into a different block and reduce contention on the block.
The DBA may also need to adjust the pctfree and/or pctused parameters for the table to ensure the rows are placed into a different block.
2. Inefficient Queries ˆ
as with the gc cr request wait event,
the more blocks requested from the buffer cache the more likelihood of a session having to wait for other sessions.Tuning queries to access
fewer blocks will often result in less contention for the same block.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/2317695/viewspace-2648622/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- wait event:gc buffer busyAIGC
- gc buffer busy的優化GC優化
- gc buffer busy的最佳化GC
- gc buffer busy acquire問題處理GCUI
- rac 遭遇GC BUFFER BUSY 處理思路GC
- GC BUFFER BUSY問題的診斷GC
- 一次GC BUFFER BUSY處理GC
- Buffer Cache以及buffer busy waits/gc相關事件AIGC事件
- GC Buffer Busy Waits in RAC: Finding Hot BlocksGCAIBloC
- RAC遇到GC Buffer Busy的解決方法2GC
- RAC遇到GC Buffer Busy的解決方法1GC
- 一次gc buffer busy問題的診斷GC
- 記一次gc buffer busy等待事件的處理GC事件
- 分析解決11gR2 雙節點RAC環境下的gc cr block busy/gc buffer busy acquire等待GCBloCUI
- Oracle Buffer Busy WaitsOracleAI
- buffer busy wait 解析AI
- 【等待事件】buffer busy waits事件AI
- Buffer Busy Wait小結AI
- zt_buffer busy waitAI
- gc current/cr block busy等待事件GCBloC事件
- Buffer Busy Waits深入分析AI
- 等待模擬-BUFFER BUSY WAITAI
- buffer busy wait 的深度剖析AI
- buffer cache實驗7-buffer busy waits-完成AI
- Buffer busy waits/read by other sessionAISession
- buffer busy wait 等待事件說明AI事件
- buffer busy waits你誤解了嗎?AI
- buffer busy wait 等待事件說明(轉)AI事件
- buffer busy waits引起的會話突增AI會話
- oracle buffer busy waits等待的含義OracleAI
- buffer busy waits 平均等待時間AI
- gc current block busy和LMS優先順序GCBloC
- 【TUNE_ORACLE】等待事件之“buffer busy waits”Oracle事件AI
- Buffer Busy Waits是怎麼產生的?AI
- Oracle資料庫buffer busy wait等待事件 (2)Oracle資料庫AI事件
- Oracle資料庫buffer busy wait等待事件 (1)Oracle資料庫AI事件
- update/select也可能產生buffer busy waits。AI
- [摘錄]Oracle Wait Interface之Buffer busy waits事件OracleAI事件