Bug 9239863 - Excessive "library cache:mutex X" contention on hot objects (文档 ID 9239863.8)
来源:互联网 发布:电火花线切割编程 编辑:程序博客网 时间:2024/05/27 10:43
Bug 9239863 Excessive "library cache:mutex X" contention on hot objects
This note gives a brief overview of bug 9239863.The content was last updated on: 28-JUN-2013
Click here for details of each of the sections below.
Affects:
Product (Component)Oracle Server (Rdbms)Range of versions believed to be affectedVersions BELOW 12.1Versions confirmed as being affectedPlatforms affectedGeneric (all / most platforms affected)
- 11.2.0.1
- 11.1.0.7
Fixed:
This issue is fixed in
- 12.1.0.1 (Base Release)
- 11.2.0.2 (Server Patch Set)
- 11.2.0.1 Bundle Patch 6 for Exadata Database
Symptoms:
Related To:
- Code Improvement
- Mutex Contention
- Waits for "library cache: mutex X"
- _kgl_hot_object_copies
- _KGL_DEBUG
Description
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.When there is *true* contention on a specific library cache object then performance of the instance might be bottlenecked on "library cache: mutex X" waits for that object. This fix is really an enhancement to allow specific objectswhich are known to exhibit high contention to be marked suchthat the contention can be reduced (by holding multiple copies of the object in the library cache). Rediscovery Notes: The following query may help identify objects being accessed heavily: select KGLNAOBJ, KGLNAOWN, KGLHDNSP, KGLOBTYP, KGLOBT23, KGLOBT24 from x$kglob where KGLOBT23 > 1000000 or KGLOBT24 > 1000000 order by KGLOBT24; Note: This fix requires special configuration via hidden parameters to have any effect. The fix should only be enabled under the guidance of Oracle Support.
References
Bug:9239863 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition
0 0
- Bug 9239863 - Excessive "library cache:mutex X" contention on hot objects (文档 ID 9239863.8)
- Bug 7307972 - Excessive waits on 'library cache: mutex x' (文档 ID 7307972.8)
- " Library Cache: Mutex X " On Koka Cursors (LOBs) Non-Shared : (文档 ID 758674.1)
- Troubleshooting 'library cache: mutex X' waits. (文档 ID 1357946.1)
- WAITEVENT: "library cache: mutex X" (文档 ID 727400.1)
- Troubleshooting 'library cache: mutex X' Waits. (文档 ID 1357946.1)
- WAITEVENT: "library cache: mutex X" (文档 ID 727400.1)
- Troubleshooting 'library cache: mutex X' waits. (文档 ID 1357946.1)
- "Cursor: Pin S Wait On X" Contention Mutex Sleep Reason Primarily (文档 ID 1268724.1)
- library cache: mutex X
- library cache: mutex X
- Troubleshooting: Tuning the Shared Pool and Tuning Library Cache Latch Contention (文档 ID 62143.1)
- 常见问题:'cursor:mutex ..'/ 'cursor:pin ..'/ 'library cache:mutex ..'类型的等待事件 (文档 ID 1525791.1)
- 常见问题:'cursor:mutex ..'/ 'cursor:pin ..'/ 'library cache:mutex ..'类型的等待事件 (文档 ID 1525791.1)
- Oracle wait event --- library cache: mutex X
- 11g等待事library cache: mutex X
- 11g等待事件之library cache: mutex X
- 11g等待事件之library cache: mutex X
- Android系列教程之十二:Intents and Intent Filters(三)
- 特殊符号
- YUV颜色空间
- HTTPS是如何保证连接安全:每位Web开发者都应知道的
- HSV颜色空间
- Bug 9239863 - Excessive "library cache:mutex X" contention on hot objects (文档 ID 9239863.8)
- Android中关于线程使用的几点注意事项
- Qt4.8下应用OpenCV2.4.4搭建环境详细步骤(win7系统)
- IOS学习笔记23—多线程之NSThread、NSOperation、NSInvocationOperation
- win7下搭建qt+opencv编程环境详细步骤...我的血泪史,希望能帮到正在学习的人!
- 数据结构实验之栈四:括号匹配
- android调用平台功能
- Android中为图标加上数字--用于未读短信数提醒,待更新应用数提醒等
- 最新 Unity3D 读取XML中的内容代码