Internal
2012-09-19
Oracle Kernel : Function kglic & Library Cache Latch
2012-09-19 08:27
最近在客户的一个案例中，遇到Latch : Library Cache的竞争，其竞争位于kglic函数调用。
以下是关于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)
以下是关于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)
历史上的今天
- 2019-09-19 Oracle 20c 新特性:SQL 宏支持(SQL Macro)Scalar 和 Table 模式
- 2014-09-19 Larry Ellison卸任Oracle公司CEO 一个时代的终结
- 2013-09-19 甲骨文全球大会2013旧金山-一路飞来揽日月
- 2010-09-19 ACOUG 第六次地面活动 小记
- 2009-09-19 如何手工创建（Create）一个Oracle 10g数据库
- 2007-09-19 《深入浅出Oracle》印刷万册纪念
- 2006-09-19 Oracle初学者入门指南-Oracle的价格
- 2006-09-19 高级复制下如何强制删除复制组
- 2006-09-19 《深入浅出Oracle》技术交流会视频下载
- 2005-09-19 Red Hat Magazine, Issue #11 发布
- 2004-09-19 Undo Internal的研究
