select /*+ ORDERED */ w.session_id waiting_session,
h.session_id holding_session,
w.lock_type,
h.mode_held,
w.mode_requested,
w.lock_id1,
w.lock_id2
from sys.dba_lock w, sys.dba_lock h
where
(((h.mode_held != 'None') and (h.mode_held != 'Null')
and ((h.mode_requested = 'None') or (h.mode_requested = 'Null')))
and
(((w.mode_held = 'None') or (w.mode_held = 'Null'))
and ((w.mode_requested != 'None') and (w.mode_requested != 'Null'))))
and w.lock_type = h.lock_type
and w.lock_id1 = h.lock_id1
and w.lock_id2 = h.lock_id2
and w.session_id != h.session_id
Comments