以下是关于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) |
|
我的世界国际版老版
我的世界国际版正式版是一款拥有超高自由度玩法是沙盒手游,经典
我的世界国际版完整版
我的世界国际服完整版是一款十分经典好玩的mc沙盒类游戏,在海
摩托车销售模拟器内置菜单中文版
摩托车出售模拟器,又名摩托车销售模拟器,这是一个以摩托车销售
船舶模拟2020最新版
船舶模拟2020是玩法非常有意思的模拟驾驶游戏,高清3d画质
油管主播的生活2内置菜单版
油管主播的生活2内置菜单版是一款模拟养成类游戏,在这里你将体