oracle top 5 timed events,oracle gcr sleep in the Top Timed Events in report

如下图所示：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.

请忽略该事件，他的出现我不代表有性能问题