遇到Library cache load lock 等待事件
来源:互联网 发布:mysql中外键约束 编辑:程序博客网 时间:2024/05/21 00:53
遇到Library cache load lock 等待事件:
在Troubleshooting Library Cache: Lock, Pin and Load Lock (Doc ID 444560.1)这篇文章中,详细解释了该等待事件:
If an object is not in memory, then a library cache lock cannot be acquired on it. The object has to be loaded into the memory to acquire the lock. The session tries to find the load lock for the database object so that it can load the object. In order to prevent multiple processes requesting the load of the same object simultaneously, the other requesting sessions have to wait for the library cache load lock as the lock is busy with loading the object into the memory. The waits on the library cache load lock is due to the objects not being available in memory. The unavailability of the library cache object in the library cache is due to the undersized shared pool causing frequent reloads or too many hard parse as a result of unshared sqls.
有如下几种方法避免该等待事件的发生:
•Increase the shared pool ( to avoid high reloads)•Increase the session cached cursors (to avoid the cursors flushing out of shared pool)•Set cursor_sharing to force (to reduce hard parsing)--again this may change the plan and performance of query. This will change literals to use binds; so plan may change:
后来总结了一下:
该db上之所以发生Library cache load lock等待事件,是因为将shared_pool_size的大小减小了。看来,貌似简单的操作,可能会引起很多问题。于是后来找时间加大了shared_pool_size
DBA在生产库上的一举一动都可能引起各种问题。慎重!
0 0
- 遇到Library cache load lock 等待事件
- Oracle grant 授权 出现 library cache lock 等待事件 处理
- 关于library cache pin和lock等待事件的理解
- cursor:mutex S和library cache lock 等待事件
- Oracle 11g下重现library cache lock等待事件
- 发现个library cache LOCK AND library cache pin 等待事件
- LIBRARY CACHE PIN 等待事件
- library cache latch等待事件
- library cache pin等待事件
- library cache pin 和lock 等待分析
- library cache pin和lock等待分析
- OEM 12c不能正常启动,同时repository数据库大量library cache lock等待事件
- Library Cache 诊断:Lock, Pin 以及 Load Lock
- library cache pin等待事件处理
- library cache pin等待事件的处理
- library cache lock事件【10G】实验
- [转载]编译存储过程时遇到的library cache pin等待事件解决过程
- impdp时卡住,DW等待library cache lock
- 如何把事情做到最好读书笔记8------(终结篇)
- PHP获取当前域名$_SERVER['HTTP_HOST']和$_SERVER['SERVER_NAME']的区别
- LoadRunner脚本优化之—参数化迭代介
- 初学者Android环境搭建
- 多总结
- 遇到Library cache load lock 等待事件
- 滤波器性能指标
- C# 禁用backspace键
- jQuery的deferred对象使用详解
- JAVA 网络编程 UDP通信
- 直方图均衡化-彩色图
- RequiredFieldValidator验证
- cloudera manager 添加开机启动
- Android UI 优化<merge/> <include/> <ViewStub>