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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Buffer Cache以及buffer busy waits/gc相關事件AIGC事件
- gc buffer busy acquire問題處理GCUI
- GC Buffer Busy Waits in RAC: Finding Hot BlocksGCAIBloC
- 一次gc buffer busy問題的診斷GC
- Oracle Buffer Busy WaitsOracleAI
- gc current/cr block busy等待事件GCBloC事件
- buffer busy wait 等待事件說明(轉)AI事件
- buffer busy waits引起的會話突增AI會話
- oracle buffer busy waits等待的含義OracleAI
- Buffer Busy Waits是怎麼產生的?AI
- [20180305]手工模擬buffer busy wait.txtAI
- 【TUNE_ORACLE】等待事件之“buffer busy waits”Oracle事件AI
- Oracle優化案例-Bug 5552515引起的buffer busy waits和表物理讀(二十四)Oracle優化AI
- Full GC (Metadata GC Threshold)GC
- 從CLR GC到CoreCLR GCGC
- IO之核心buffer----"buffer cache"
- GCGC
- GC.MaxGeneration屬性【GC示例】GC
- ORA-00054: resource busy and acquire with NOWAIT specifiedUIAI
- Educational Codeforces Round 100-C. Busy Robot
- protocol bufferProtocol
- 【node】Buffer
- GC是什麼?為什麼要有GC?GC
- JVM 系列文章之 Full GC 和 Minor GCJVMGC
- 【BUFFER】Oracle buffer cache之 latch 學習記錄Oracle
- JAVA NIO BufferJava
- bytes.Buffer
- Java NIO - BufferJava
- TUNING THE REDOLOG BUFFER
- Buffer和Channel
- 14.5.4 Log Buffer
- 14.6.5 Doublewrite buffer
- 總結Minor GC、Full GC觸發條件GC
- ORA-00054: resource busy and acquire with NOWAIT specified處理UIAI
- python的GCPythonGC
- java GC CollectorJavaGC
- gc 檢視GC
- TarsGo支援Protocol BufferGoProtocol