VIEW: SYS.DBA_BLOCKERS

Source

View Text - Preformatted

select /*+ordered */ distinct s.ksusenum holding_session, s.con_id con_id
  from v$session_wait w, x$ksqrs r, v$_lock l, x$ksuse s
 where w.wait_Time = 0
   and w.event like 'enq:%'
   and r.ksqrsid1 = w.p2
   and r.ksqrsid2 = w.p3
   and r.ksqrsidt = chr(bitand(p1,4278190080)/16777215)||
                   chr(bitand(p1,16711680)/65535)
   and l.block = 1
   and l.saddr = s.addr
   and l.raddr = r.addr
   and s.inst_id = userenv('Instance')

View Text - HTML Formatted

SELECT /*+ORDERED */ DISTINCT S.KSUSENUM HOLDING_SESSION
, S.CON_ID CON_ID
FROM V$SESSION_WAIT W
, X$KSQRS R
, V$_LOCK L
, X$KSUSE S
WHERE W.WAIT_TIME = 0
AND W.EVENT LIKE 'ENQ:%'
AND R.KSQRSID1 = W.P2
AND R.KSQRSID2 = W.P3
AND R.KSQRSIDT = CHR(BITAND(P1
, 4278190080)/16777215)|| CHR(BITAND(P1
, 16711680)/65535)
AND L.BLOCK = 1
AND L.SADDR = S.ADDR
AND L.RADDR = R.ADDR
AND S.INST_ID = USERENV('INSTANCE')