How to determine which blocked PL / SQL package (Oracle 10.0.4.2)?

Question

I tried to recompile the PL / SQL package and to no avail. because something got the castle, and it wasn’t released for a long time. As soon as I kill all the sessions, I was able to recompile, but encountered the same behavior (i.e. a Blocked package), and I wonder what tools are available to determine what can be obtained and not released? This happens (Oracle 10.2.0.4). Many thanks for your help.

Answer 1

I think you mean 10.2.0.4, since there is no 10.0.xx series of versions

select * from v$locked_object lo join dba_objects o on lo.object_id = o.object_id where o.object_name = 'xxPACKAGE NAMExx' and o.object_type = 'PACKAGE';