ITPub博客

首页 > 数据库 > Oracle > gc cr request等待事件

gc cr request等待事件

Oracle 作者:东北胖子 时间:2019-05-17 17:08:04 0 删除 编辑

    The session is looking for a consistent read version of data but cannot find it in the local cache. The local instance has made a request to other RAC instances for the data and is waiting on its return. Solutions Collect more information about the average time the instances are waiting for this type of request: select b1.inst_id, b2.value 'GCS CR BLOCKS RECEIVED', b1.value 'GCS CR BLOCK RECEIVE TIME', ((b1.value / b2.value) * 10) 'AVG CR BLOCK RECEIVE TIME (ms)' from gv$sysstat b1, gv$sysstat b2 where b1.name = 'global cache cr block receive time' and b2.name = 'global cache cr blocks received' and b1.inst_id = b2.inst_id; If the average cr block receive time is more than 15 milliseconds, this implies the session is waiting excessively for the block request to be satisfied by other instances. If the average time is less, that implies an excessive amount of block requests are occurring.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/2317695/viewspace-2644790/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2012-03-09

  • 博文量
    69
  • 访问量
    138746