以下是关于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) |
|
模拟极限越野
模拟极限越野开着大巴在各种奇葩路况里送乘客。山路弯道多得让人
模拟火车
模拟火车让你当回真正的火车司机,得先学会看信号灯、操作控制杆
可口的披萨美味的披萨
可口的披萨美味的披萨带您体验经营一家披萨店的乐趣。游戏画风温
定制虚拟偶像最新版
定制虚拟偶像最新版是一款超级经典有趣的日本模拟装扮类型的手游
病娇模拟器手机版正版(yandere simulator)
病娇模拟器最新版手游是一款萌妹二次元模拟游戏,玩家在游戏中可