How to free a locked object?

From: dbagtcol <cx4gtcol_at_gmail.com>
Date: Wed, 23 Jan 2008 00:37:28 -0800 (PST)
Message-ID: <15d22e09-a0f7-4667-ad3d-8d43e426b98d@d21g2000prf.googlegroups.com>


hi all,
I'm trying a compile a proc but the run would just go forever and throw 'ORA-04021: timeout occurred while waiting to lock object xxx' at the end. Upon checking the v$session_wait, i found "latch: cache buffers chains" as Event and "Concurrency" as Wait_class. On checking v $locked_object, i found one object being held. I don't have access to alert_log file. How do I find who is using this object and how do I free it for myself?

Appreciate your kind responses.
gtcol Received on Wed Jan 23 2008 - 02:37:28 CST

Original text of this message