热门标签 | HotTags
当前位置:  开发笔记 > 编程语言 > 正文

OracleKernel:Functionkglic&LibraryCacheLatch-mysql教程

OracleKernel:Functionkglic&LibraryCacheLatch有碰到此类问题的朋友可以一起参考一下本文章。

Oracle Kernel : Function kglic & Library Cache Latch 有碰到此类问题的朋友可以一起参考一下本文章。

Oracle Kernel : Function kglic & Library Cache Latch 有碰到此类问题的朋友可以一起参考一下本文章。

以下是关于KGLIC函数的功能简要说明:

代码如下

1. kglic means Kernel Generic Library cache Iterate Chain (AFAIK), it's the function which is executed when you access most X$KGL tables.

2. kglic is the code which goes through the library cache and row cache to answer queries on various dictionary fixed views and tables. This is the function which returns data for the fixed views and tables that scan the sql area. Therefore, it was highly possible that such queries could also be coming from monitoring tools used by DBAs and they are not restricted to the two views specifically mentioned in the bug by Joan. Any monitoring job which looks at v$open_cursor would also use the kglic iterator.

与此相关的BUG,在10g中仍然存在,最后确认客户有较为频繁的查询访问v$sql视图,导致了严重的library cache的竞争。

以下BUG的影响版本为10.2.0.4,10.2.0.5,11.2.0.2 :

代码如下
Bug 9287616 - Accessing [G]V$SQL or [G]V$SQLTEXT_WITH_NEWLINES may be slow / takes a long time / latch contention (Doc ID 9287616.8)

推荐阅读
author-avatar
黄骏捷
这个家伙很懒,什么也没留下!
PHP1.CN | 中国最专业的PHP中文社区 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved | 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有