Re: library cache lock

From: Danisment Gazi Unal (ubTools) <dunal_at_ubTools.com>
Date: Wed, 2 Jun 2004 16:45:29 +0300
Message-ID: <023801c448a7$e0f8b330$fe19100a@danismentgu>

library cache lockHi,

See Metalink Note:122793.1. If you need SYSTEMSTATE dump interpretation, let us know.

best regards...

http://www.ubTools.com
Web Based Oracle Products and Services

Original Message ----- From: David Sharples To: oracle-l_at_freelists.org Sent: Wednesday, June 02, 2004 4:40 PM Subject: RE: library cache lock

I searched (probably on wrong words) didn't return anything useful as I could see, can you show me a url?

  From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Khedr, Waleed   Sent: 02 June 2004 14:10
  To: oracle-l_at_freelists.org
  Subject: RE: library cache lock

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:42:16 CDT