oracle gcr sleep in the Top Timed Events in report
Applies to:
Oracle Server - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.
Goal
The GCR sleep Event is appearing in the Top 5 Timed Events in a statspack
report.
How do I manage this event in order to improve performance.
Fix
The GCR sleep event is an Idle Wait Event.
該等待事件為空的等待事件
This event should not be
included by statspack when reporting on the Top Timed Events.
該事件正常情況下應該不包含在statspack報告的TOP TIMED EVENTS裡
The
following internal bug covers this issue:
Bug 9695145 STATSPACK
STANDBY: UPGRADE SCRIPT MISSING NEW IDLE EVENTS
This bug will be fixed in
the next patchset release (11.2.0.4)
該BUG將在11.2.0.4版本修補
Please ignore the GCR sleep Event as
it does not represent a performance issue.
請忽略該事件,他的出現我不代表有效能問題
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29446986/viewspace-1452870/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- AWR--Top 5 Timed Foreground Events
- 10gTop N Timed Events統計
- oracle eventsOracle
- ORACLE EVENTS(轉)Oracle
- oracle set eventsOracle
- dump oracle events(轉)Oracle
- Oracle Statspack ReportOracle
- Oracle RAC Wait EventsOracleAI
- Detailed Item Cost Report (XML) timed out waiting for the Output Post-processor to finishAIXML
- oracle DBMS_LOCK.SLEEP()的使用Oracle
- Oracle Enqueues Wait Events 二OracleENQAI
- Oracle Enqueues Wait Events 一OracleENQAI
- Oracle Enqueues Wait Events 三OracleENQAI
- Oracle跟蹤事件 -- set eventsOracle事件
- 幾個ORACLE wait eventsOracleAI
- k8s.gcr.io、gcr.io倉庫的映象下載K8SGC
- Oracle TIMED_STATISTICS 引數 說明Oracle
- Oracle所有診斷事件列表eventsOracle事件
- alter session set events /Oracle跟蹤SessionOracle
- [zt]Oracle跟蹤事件 - set eventsOracle事件
- Oracle跟蹤事件:set events 整理Oracle事件
- 全面學習ORACLE Scheduler特性(7)使用Events之Scheduler丟擲的EventsOracle
- oracle中 Wait Events 和可能原因(oracle doc)OracleAI
- 延時函式delay() sleep() Sleep()函式
- Oracle Events(個人參考資料)ztOracle
- 【Oracle】Master Note for Parallel Execution Wait EventsOracleASTParallelAI
- 全面學習ORACLE Scheduler特性(8)使用Events之Application丟擲的EventsOracleAPP
- Oracle EBS Form & Report 問題大全OracleORM
- oracle 11.2.0.3 grid ons 程式 checked timed outOracle
- 【Oracle】 inbound connection timed out (ORA-3136)Oracle
- 【Oracle】alter system set events 相關知識Oracle
- ORACLE等待事件型別【Classes of Wait Events】Oracle事件型別AI
- ORACLE TOP SQLOracleSQL
- Oracle RAC Cache Fusion系列十八:Oracle RAC Statisticsand Wait EventsOracleAI
- For oracle databases, if the top showing the oracle database, then oracle process is using the top cOracleDatabase
- oracle分析函式之ratio_to_reportOracle函式
- Oracle 10g AWR Report 分析(轉)Oracle 10g
- [Oracle Script] Top sqlOracleSQL