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>
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