title: How to identify what locked PL/SQL package (Oracle 10.0.4.2)?
body: <p>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.2.0.4).  Greatly appreciate for your help. </p>