gc buffer busy acquire問題處理
某日19點,客戶反饋出現卡頓。資料庫版本為:11.2.0.4的rac環境
分別檢視2個節點awr的等待事件:
節點1:enq: TX - index contention
節點2:gc buffer busy acquire
檢視mos:
根據 workaround 可以設定 _gc_read_mostly_locking=FALSE後,問題已解決。
來自 “ ITPUB部落格 ” ,連結:https://blog.itpub.net/70021989/viewspace-3006619/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rac 遭遇GC BUFFER BUSY 處理思路GC
- 一次GC BUFFER BUSY處理GC
- GC BUFFER BUSY問題的診斷GC
- gc buffer busyGC
- 記一次gc buffer busy等待事件的處理GC事件
- 一次gc buffer busy問題的診斷GC
- 分析解決11gR2 雙節點RAC環境下的gc cr block busy/gc buffer busy acquire等待GCBloCUI
- wait event:gc buffer busyAIGC
- gc buffer busy的優化GC優化
- gc buffer busy的最佳化GC
- ORA-00054: resource busy and acquire with NOWAIT specified處理UIAI
- Buffer Cache以及buffer busy waits/gc相關事件AIGC事件
- 新建partition出現 device busy問題處理dev
- GC Buffer Busy Waits in RAC: Finding Hot BlocksGCAIBloC
- RAC遇到GC Buffer Busy的解決方法2GC
- RAC遇到GC Buffer Busy的解決方法1GC
- ORA-00054:resource busy and acquire with nowaitUIAI
- ORA-00054: resource busy and acquire with NOWAITUIAI
- Oracle Buffer Busy WaitsOracleAI
- buffer busy wait 解析AI
- ORA-00054,ORA-00031 resource busy and acquire with NOWAIT 資源佔用處理過程UIAI
- ORA-00054: resource busy and acquire with NOWAIT specifiedUIAI
- ora-00054:resource busy and acquire with nowait specifiedUIAI
- 【等待事件】buffer busy waits事件AI
- Buffer Busy Wait小結AI
- zt_buffer busy waitAI
- oracle之 RA-00054: resource busy and acquire with NOWAITOracleUIAI
- 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
- ora-00054:resource busy and acquire with nowait specified解決方法UIAI
- 處理問題的方法
- perl中文處理問題