最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
Oracle Kernel : Function kglic & Library Cache Latch
时间：2022-06-29 10:05:31 编辑：袖梨 来源：一聚教程网
以下是关于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) |
|
相关文章
- 原神月之四「如果在冬夜 一个旅人」魔神任务介绍 08-01
- qq邮箱网页版登录入口-qq邮箱登陆地址 08-01
- 异人之下官网入口在哪-官网入口地址分享 08-01
- 全明星觉醒 黑子的测验挑战攻略 全明星觉醒 如何通关黑子的测验 08-01
- CrazyGames官方入口下载-CrazyGames官方免费下载入口 08-01
- 漫画网址下载入口-漫画网址资源下载汇总 08-01