Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE	11.2.0.1.0	Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

begin
MMM.TOP.P_BUILD;
end;

SELECT s.sid,
l.lock_type,
l.mode_held,
l.mode_requested,
l.lock_id1
FROM   dba_lock_internal l,
v$session s
WHERE s.sid = l.session_id
AND UPPER(l.lock_id1) LIKE '%MMM%'
AND l.lock_type = 'Body Definition Lock';


sid    lock_type                  mode_held  mode_requested  lock_id1
---------------------------------------------------------------------------------
15	Body Definition Lock	   Null	       None	     MMM.TOP




В представлении dba_ddl_locks то видно следующее:

SELECT * from   dba_ddl_locks where owner='MMM'; 

SESSION_ID OWNER NAME        TYPE                       MODE_HELD      MODE_REQUESTED
---------------------------------------------------------------------------------
15          MMM	 TOP	     Body	                 Null	       None
15	    MMM  TOP     Table/Procedure/Type	         Null          None
  



select EVENT from V$SESSION_WAIT where SID='15'; 

EVENT
---------------------------------------------------------------------------------
PX Deq Credit: send blkd

Blocking_Session/Final_Blocking_Session - пусты

ALTER PACKAGE MMM.TOP COMPILE PACKAGE; 
   
ALTER PACKAGE MMM.TOP COMPILE BODY;