How to free a locked object?

[gtcol]

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

[TPT]

You can write a query by joining v$session and v$ssesion_wait and can come to know about who is using which object.

[gtcol]

Dear,
Can you elaborate this a bit? How does it tell me who is locking the object?

[paragp1981]

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)

[gtcol]

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

[Kailash Chandra]

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.

[PAVB]

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 am
Issue got solved the very same day before 7:54 am

May I ask why you decided to add your post on February 5th?

[abhaysk]

lemme guess, for publicity?

[hrishy]

Just wundering do people understand the meaning of a thread a forum etc.

regards
Hrishy