Re: library cache lock

From: "Diego Cutrone" <diegocutrone@xxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 2 Jun 2004 11:28:42 -0700

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@xxxxxxxxxxxxx 
  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

References:
- library cache lock
  - From: David Sharples

Re: library cache lock

Other related posts: