library cache: mutex X
来源:互联网 发布:淘宝兼职外宣经典说说 编辑:程序博客网 时间:2024/05/22 03:39
我们先来看看 library cache: mutex X 。 是个什么东西 The library cache mutex is acquired for similar purposes that the library cache latches were acquired in prior versions of Oracle. In 10g, mutexes were introduced for certain operations in the library cache. Starting with 11g, the library cache latches were replaced by mutexes, hence this new wait event. -----摘自metalink [ID 727400.1]library cahce 互斥需要的目的;类似于10g中library cache lacthes的目的。在10g中,mutexes 迎来说明library cache中的某些操作。在11G中,libary cache latches 被mulexes替换。同时oracle也给出了追踪的办法。Systemwide Waits:At a systemwide level, there are two views which will help diagnose this wait:GV$MUTEX_SLEEP (or V$MUTEX_SLEEPS for non-RAC)and GV$MUTEX_SLEEP_HISTORY (or V$MUTEX_SLEEP_HISTORY for non-RAC)These views track the instance wide usage of mutexes since instance startup. Since these views show values that are total values since startup, they are most meaningful when you obtain the difference in values during a short time interval when there was problem. The easiest way to see this information is through an AWR or statspack report in the "Mutex Sleep Summary" section. Finding Blockers: You can see the P2 value in V$MUTEX_SLEEP_HISTORY along with the "REQUESTING_SESSION". You may find a pattern where one session commonly blocks others - this would lead you to obtain a SQL trace of the blocking session to try and get more information about what its doing.
0 0
- library cache: mutex X
- library cache: mutex X
- Oracle wait event --- library cache: mutex X
- Troubleshooting 'library cache: mutex X' waits. (文档 ID 1357946.1)
- WAITEVENT: "library cache: mutex X" (文档 ID 727400.1)
- 11g等待事library cache: mutex X
- 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)
- 11g等待事件之library cache: mutex X
- 11g等待事件之library cache: mutex X
- 关于Oracle 数据库等待事件library cache: mutex X
- oracle 11gR2 rac library cache: mutex X引发的故障
- 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)
- Database Performance: How to reduce "library cache: mutex X" waits for scalability in the Oracle dat
- cursor:mutex S和library cache lock 等待事件
- FileUtil
- JPA概要
- 控制音量大小widget
- 算法之二叉树各种遍历
- Kryo序列化进阶学习: 加密数据
- library cache: mutex X
- 【180网站】22-28
- [Android] AsyncTask详解
- CmakeList.txt 简单说明(PCL 实例)
- windows socket编程UDP篇
- 遮罩层
- sql语句实现增加表、字段描述性文字
- 头文件注释轻松搞—VS2013
- mysql 分页查询语句数据库查询