A user is complaining that he can't compile his package because something has it locked. First he tried to compile with TOAD, which just freezes and eventually times out. Then in Sqlplus, he got the message that it timed out waiting for a lock.
There are no records with the package or package body's object_id in dba_lock, v$lock, v$locked_object.
I'm sure I could just bounce the db since it's development but would rather try to find the solution
He's not running the procedure, just compiling, so there shouldn't be a problem with other objects (tables referenced in the procedure, etc) correct?
Click Here to Expand Forum to Full Width