我们先来看看 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.
library cache: mutex X
转载本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
上一篇:linux sar查看网络流量
下一篇:translate函数说明
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
深入学习cache--思考篇
ARMv8/ARMv9架构精选系列
v8 v9 个人博客 -
关于Oracle 数据库等待事件library cache: mutex X
关于Oracle 数据库等待事件library cache: mutex X
library cache mutex X oracle perl css -
cursor: mutex X
清除共享池中的SQL执行计划:exec dbms_shared_pool.purge('<address,hash_value>','C');
12c cursor: mutex X 清除共享池中的SQL执行计划 -
哪种操作需要哪种类型的library cache lock / library cache pin?
哪种操作需要哪种类型的library cache lock / library cache pin?
library cache pin library cache lock sed sql