RE: Fun with WAIT Event "library cache: mutex X"
Date: Sat, 10 Dec 2011 18:50:01 +0000
Message-ID: <ED8913458C966249856499C923CE5C8B18CCD7F4_at_prd-dag-01.ad.sprich.com>
Had a similar problem in 11.0.1.
Turned out to be a bug of some type.
Use this query and see if your query has a very high cursor count.
select a.cursors, a.sql_id,b.sql_text
from
(
select count(*) as cursors, ssc.sql_id
from v$sql_shared_cursor ssc
group by ssc.sql_id
order by cursors desc
) a,
(
select sa.sql_id, sa.sql_text from v$sqlarea sa
) b
where a.sql_id=b.sql_id
Then run:
SELECT address||','||hash_value, version_count FROM v$sqlarea WHERE sql_id = '<your sql_id>';
Then purge it from the shared pool with: EXECUTE dbms_shared_pool.purge('C0000004C29DEAA8,3868811517','C',1);
Of course you need to substitute what the previous query retured.
Then rerun your query that had the mutex X wait.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David
Sent: Friday, December 09, 2011 10:10 AM
To: 'Herring Dave - dherri'; 'oracle-l_at_freelists.org'
Subject: RE: Fun with WAIT Event "library cache: mutex X"
I'll take a look at that.
Thanks,
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.
-----Original Message-----
From: Herring Dave - dherri [mailto:Dave.Herring_at_acxiom.com]
Sent: Friday, December 09, 2011 8:58 AM
To: Taylor, Chris David; 'oracle-l_at_freelists.org'
Subject: RE: Fun with WAIT Event "library cache: mutex X"
On the much less important point you made about " It is only *4 GIGABYTES*. I'm getting about 170k download speed on my work network so......", are you usin wget? I found speeds much faster using this, plus it allows direct download to my server instead of going to PC, then PC to server. It also appears to be only available through the flash version of MOS.
DAVID HERRING
DBA
Acxiom Corporation
EML dave.herring_at_acxiom.com TEL 630.944.4762 MBL 630.430.5988
1501 Opus Pl, Downers Grove, IL 60515, USA WWW.ACXIOM.COM
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David
Sent: Thursday, December 08, 2011 10:46 AM
To: 'oracle-l_at_freelists.org'
Subject: Fun with WAIT Event "library cache: mutex X"
I'm running 11.2.0.2 Patch 10 on Windows x64 and I have a pl/sql procedure that is rather simple, but kept erroring out after some time with an out memory condition. So, I decided to look and see what it is doing and it is encountering the "library cache: mutex X" event.
Browing Oracle Support, I found the note about it and it says:
- "P3 = "where" = location in code (internal identifier) where mutex is being waited for _at_The meaning of the code for "where" can be found by looking in kgl0.h for entries with the prefix ""kglml_XXX". For example, if P3=2, then it corresponds to "kglml_kglget2". You can then search source code for this symbol to see where the mutex is acquired.
Well, that's not very helpful to me since I don't have access to the source code :) I understand that the engineers can use it.
Long story short, I decided to download the 11.2.0.3 patchset.
It is only *4 GIGABYTES*. I'm getting about 170k download speed on my work network so......
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Dec 10 2011 - 12:50:01 CST