RE: library cache lock

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 2 Jun 2004 09:09:44 -0400
Message-ID: <42BBD772AC30EA428B057864E203C999274208@MSGBOSCLF2WIN.DMN1.FMR.COM>

The metalink has answers for similar issues.  

-----Original Message-----

From: David Sharples [mailto:dsharples_at_cerebrussolutions.com] Sent: Wednesday, June 02, 2004 8:44 AM
To: oracle-l_at_freelists.org
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 - 08:06:48 CDT