Hi All,
I am using 11Gr2. Here , I have got one issue , where I am getting "library cache: mutex X" wait events when querying the package name from dba_objects.
I also generated the system state dump 266 , but unable to find the holder of the same mutex. any idea , how to read these dumps properly or any document/blog ,where I can get this. I also refer on metalink document (Note: 444560.1) , but it did not work for me.
one session , I queried
SQL> select SID , OWNER , OBJECT from v$access where OBJECT='PACK_OPTIO';
another session :
SID SERIAL# USERNAME STATUS EVENT
---------- ---------- ------------------------------ -------- -----------------------------------
321 51640 SYS ACTIVE library cache: mutex X
Regards