博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
global cache cr request等待事件
阅读量:5807 次
发布时间:2019-06-18

本文共 2433 字,大约阅读时间需要 8 分钟。

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. In both cases the following are suggestions for decreasing wait times: If a SQL statement is not tuned properly it may request more data blocks than necessary. Review the explain plan for the SQL and tune the statement accordingly. Reduce the latency on the network interconnect between instances. Excessive latency could be caused by: Slow network technology is being used for the interconnect or RAC has chosen the incorrect one. To verify the interconnect being used, search the alert.log file for "cluster interconnect". Under-configured network settings at the OS level. Errors occurring on the interconnect. If there are excessive waits on the remote instance's buffer cache, increase the DB_CACHE_SIZE parameter on the remote database. Tune the Lock Management System (LMS) being used to handle lock requests. If the system is heavily loaded or other scheduling delays for the LMS are present, consider increasing the number of LMS processes or increasing the priority so they get more CPU time. The parameter _LM_LMS can be used to set the number of LMS processes. Distribute the workload across instances to achieve better localized block access. If the average wait time for another wait event named "global cache null to x'" wait event is low (under 15ms) then you may be experiencing an Oracle statistics bug. This is a problem in the way statistics are reported and does not impact performance. More information can be found in Metalink Note: 243593.1. Also review Metalink Note: 181489.1 for other possible Oracle bugs.

转载地址:http://pcubx.baihongyu.com/

你可能感兴趣的文章
RustCon Asia 实录 | Distributed Actor System in Rust
查看>>
Cocos2dx源码记录(5) CCRenderCommand
查看>>
Python学习笔记 - 下载图片
查看>>
验证提示框封装
查看>>
CDN WAF功能开放公测 提升网络应用安全性能
查看>>
Python入门第三章--第三节:列表
查看>>
搭建Hexo博客相册
查看>>
RPA风潮席卷全行业,本土厂商如何把握未来?
查看>>
node 事件
查看>>
史上最全的HTML、CSS知识点总结,浅显易懂。适合入门新手
查看>>
Objective-C高级编程读书笔记(一)
查看>>
Spring Cloud OAuth 微服务内部Token传递的源码实现解析
查看>>
webpack4入门和多文件打包尝试
查看>>
云数据库将进入企业级百万IOPS时代
查看>>
社交网络大数据的应用有多大的价值
查看>>
Spring Cloud自定义引导属性源
查看>>
SQL Server 2005故障转移群集
查看>>
Linux yum和apt-get用法及区别
查看>>
python 中类中 __slots__
查看>>
C++ 随机数
查看>>