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.