oracle gcr sleep in the Top Timed Events in report

hurp_oracle發表於2015-03-09
如下圖所示:GCR sleep 等待事件佔用比例很高


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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章