How to identify what locked PL/SQL package (Oracle 10.0.4.2)?

Posted by Roman Kagan on Stack Overflow See other posts from Stack Overflow or by Roman Kagan
Published on 2010-06-10T00:29:35Z Indexed on 2010/06/10 0:32 UTC
Read the original article Hit count: 193

Filed under:
|
|
|

I was trying to recompile PL/SQL package and no avail. because something obtained the lock and that wasn't released for long time. As soon as I kill all sessions I was able to recompile but encounter the same behavior (i.e. locked package) and I wonder what tools are avail to identify what could of obtain it and never release it? This happen on (Oracle 10.0.4.2). Greatly appreciate for your help.

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about session