Printable View
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
You can write a query by joining v$session and v$ssesion_wait and can come to know about who is using which object.
Dear,
Can you elaborate this a bit? How does it tell me who is locking the object?
use v$locked_object (A),all_objects (B),v$session (C)
see which columns you need to select from above 3 views
then match foll
object_id (from A) to object_id (from B)
process (from C) to process (from A)
Hello Parag/TPT
Thanks for your prompt responses. This is what I found after googling for a while: http://www.praetoriate.com/oracle_ti...d_sessions.htm. It did really help.
Thanks,
gtcol
just run the script ...rdbms\admin\utllockt.sql you knw that which user is waiting for whom. Then you can send the mail to him or kill the session.
Issue was described as a locked object on January 23 at 3:38 amQuote:
Originally Posted by Kailash Chandra
Issue got solved the very same day before 7:54 am
May I ask why you decided to add your post on February 5th?
lemme guess, for publicity?
Just wundering do people understand the meaning of a thread a forum etc.
regards
Hrishy