Re: library cache lock

From: Diego Cutrone <diegocutrone_at_yahoo.com.ar>
Date: Wed, 2 Jun 2004 11:28:42 -0700
Message-ID: <004b01c448cf$746b5d80$4d8049c8@DC>

library cache lockDave,

To find out which session is blocking you you can also try this one:

select sid Holder ,KGLLKUSE Sesion , KGLLKMOD Held, KGLLKREQ Req from x$kgllk , v$session
where KGLLKHDL in (select p1raw from v$session_wait

                    where wait_time=0 and event like 'library cache lock%')

and KGLLKMOD <> 0
and v$session.saddr=x$kgllk.kgllkuse
/

Then after identifying the blocking session, you can go from there

HTH
Regards,
Diego

• Original Message ----- From: David Sharples To: oracle-l_at_freelists.org Sent: Wednesday, June 02, 2004 5:44 AM Subject: library cache lock

  Hi, got a strange problem. I am trying to truncate a partition in a table, but it just hangs forever, it is waiting on a library cache lock. Anyone know why and how I can clear it - flushing the shared pool didn't help and there are no other sessions touching that table.

  Thanks

  Dave

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Jun 02 2004 - 09:23:02 CDT