ITPub博客

首页 > 数据库 > Oracle > oracle gcr sleep in the Top Timed Events in report

oracle gcr sleep in the Top Timed Events in report

原创 Oracle 作者:hurp_oracle 时间:2015-03-09 09:03:31 0 删除 编辑
如下图所示: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博客 ” ,链接:https://blog.itpub.net/29446986/viewspace-1452870/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-01-17

  • 博文量
    152
  • 访问量
    647370