eygle.com   eygle.com
eygle.com eygle

« 管中窥豹新特性:Oracle Pluggable Database | Blog首页 | 关于 12306 网站设计的一点信息收集 »

Oracle Kernel : Function kglic & Library Cache Latch

最近在客户的一个案例中,遇到Latch : Library Cache的竞争,其竞争位于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,, :
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文章:
    >> 2014-09-19文章:
    >> 2013-09-19文章:
    >> 2010-09-19文章:
    >> 2009-09-19文章:
    >> 2007-09-19文章:
    >> 2006-09-19文章:
    >> 2005-09-19文章:
    >> 2004-09-19文章:
           Undo Internal的研究

By eygle on 2012-09-19 08:27 | Comments (0) | Internal | 3046 |

CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com