VIEW: SYS.DBA_DDL_LOCKS

Source

View Text - Preformatted

select  s.sid session_id,
          substr(ob.kglnaown,1,30) owner,
          substr(ob.kglnaobj,1,30) name,
    decode(ob.kglhdnsp, 0, 'Cursor', 1, 'Table/Procedure/Type', 2, 'Body',
           3, 'Trigger', 4, 'Index', 5, 'Cluster', 13, 'Java Source',
             14, 'Java Resource', 32, 'Java Data', to_char(ob.kglhdnsp)) type,
    decode(lk.kgllkmod, 0, 'None', 1, 'Null', 2, 'Share', 3, 'Exclusive',
	   'Unknown') mode_held,
    decode(lk.kgllkreq,  0, 'None', 1, 'Null', 2, 'Share', 3, 'Exclusive',
	   'Unknown') mode_requested
   from v$session s, x$kglob ob, x$kgllk lk
   where lk.kgllkhdl = ob.kglhdadr
   and   lk.kgllkuse = s.saddr
   and   ob.kglhdnsp != 0

View Text - HTML Formatted

SELECT S.SID SESSION_ID
, SUBSTR(OB.KGLNAOWN
, 1
, 30) OWNER
, SUBSTR(OB.KGLNAOBJ
, 1
, 30) NAME
, DECODE(OB.KGLHDNSP
, 0
, 'CURSOR'
, 1
, 'TABLE/PROCEDURE/TYPE'
, 2
, 'BODY'
, 3
, 'TRIGGER'
, 4
, 'INDEX'
, 5
, 'CLUSTER'
, 13
, 'JAVA SOURCE'
, 14
, 'JAVA RESOURCE'
, 32
, 'JAVA DATA'
, TO_CHAR(OB.KGLHDNSP)) TYPE
, DECODE(LK.KGLLKMOD
, 0
, 'NONE'
, 1
, 'NULL'
, 2
, 'SHARE'
, 3
, 'EXCLUSIVE'
, 'UNKNOWN') MODE_HELD
, DECODE(LK.KGLLKREQ
, 0
, 'NONE'
, 1
, 'NULL'
, 2
, 'SHARE'
, 3
, 'EXCLUSIVE'
, 'UNKNOWN') MODE_REQUESTED
FROM V$SESSION S
, X$KGLOB OB
, X$KGLLK LK
WHERE LK.KGLLKHDL = OB.KGLHDADR
AND LK.KGLLKUSE = S.SADDR
AND OB.KGLHDNSP != 0