以下是关于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) |
|
创造与魔法九游版本
创造与魔法九游版采用了极致创新的魔幻游戏玩法感受,游戏具备最
疯狂医院达什医生中文版(Crazy Hospital)
疯狂医院达什医生最新版是一款医院模拟经营类游戏,逼真的场景画
宝宝庄园官方版
宝宝庄园官方版是一款超级经典好玩的模拟经营类型的手游,这个游
桃源记官方正版
桃源记是一款休闲娱乐类的水墨手绘风格打造的模拟经营手游。玩家
长途巴士模拟器手机版
长途巴士模拟器汉化版是一款十分比真好玩的大巴车模拟驾驶运营类