library cache: mutex X

Oracle Library Cache Mutex解析与诊断

最新推荐文章于 2024-10-15 10:00:00 发布

scan724

最新推荐文章于 2024-10-15 10:00:00 发布

阅读量1.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： OWI

本文链接：https://blog.youkuaiyun.com/zhaoyangjian724/article/details/26454057

OWI 专栏收录该内容

87 篇文章 ¥39.90 ¥99.00

订阅专栏

本文探讨了Oracle中的Library Cache Mutex，它在11g中替代了Library Cache Latches，用于保护library cache中的操作。通过GV$MUTEX_SLEEP和GV$MUTEX_SLEEP_HISTORY视图可以诊断等待事件，并通过AWR或Statspack报告分析问题。当出现阻塞时，可以通过V$MUTEX_SLEEP_HISTORY找出阻塞会话并进行SQL跟踪以获取更多信息。

我们先来看看 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 tra

了解本专栏