RE: library cache lock
- From: "David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Jun 2004 14:40:22 +0100
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Khedr, Waleed
Sent: 02 June 2004 14:10
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: library cache lock
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:
