RE: library cache lock

  • From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 2 Jun 2004 09:09:44 -0400

The metalink has answers for similar issues.
 

-----Original Message-----
From: David Sharples [mailto:dsharples@xxxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, June 02, 2004 8:44 AM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: