oracle library latch
来源:互联网 发布:淘宝姐优惠券助手 编辑:程序博客网 时间:2024/05/21 21:47
产生library cache latch原因
The library cache latches protect the cached SQL statements and objects' definitions held
in
the library cache within the shared pool. The library cache latch must be acquired
in
order to add a new statement to the library cache. During a parse, Oracle searches
the library cache
for
a matching statement. If one is not found,
then
Oracle will parse
the SQL statement, obtain the library cache latch and insert the new SQL.
每一个sql被执行之前,先要到library cache中根据hash_value查找parent cursor,这就需要先获得library cache latch;找到parent cursor后,就会去查找对应的child cursor,当发现无法找到时,就会释放library cache latch,获得share pool latch分配空间给硬解析后的产生的执行计划;然后再次获得library cache latch进行把执行计划放入share pool,转入library cache pin+lock(null模式)开始执行sql.library cache latch 的个数有限(与CPU_COUNT参数相关),当数据库中出现大量硬解析的时候,某一个sql无法得到library cache latch就会开始spin,达到spin count后还没得到,就会开始sleep,达到sleep时间后,醒来还再次试图过的library cache latch得不到就在spin再得不到又sleep…依此类推.
综上可知:在sql执行的过程中可以看出在出现High Versions Count和Hard Parse的情况下都有可能出现library cache latch等待.
0 0
- oracle library latch
- Oracle latch:library cache 导致 数据库挂起 故障
- Oracle Latch
- latch:library cache
- Library Cache Latch和Shared Pool Latch
- shared pool latch和library cache latch
- Oracle Latch及latch矛盾
- Oracle Latch及latch冲突
- 2.latch之oracle latch
- library cache latch等待事件
- library cache —— latch: library cache
- ORACLE parent latch和children latch
- 4.latch之oracle latch undo globaldata
- 应用Oracle latch分类
- Oracle LATCH学习
- ORACLE LATCH介绍
- oracle latch(转)
- Oracle Latch 说明
- python version 2.7 required,which was not found in the registry
- 面试题10 二进制中1的个数
- oracle数据导入导出
- apk多版本共存
- 文件的应用
- oracle library latch
- Hibernate中使用annotatation映射对象和数据库表包的导入问题
- 软件考试路线图
- 从Java反射机制到Android注解框架
- HDU 单词总数
- adb shell 调试 Android 串口
- 贪心<haonan>
- 【Debug】Hander processing failed; nested exception is java.lang.NoClassDefFoundError; javax/servlet/j
- Android的Handler使用总结