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