Lockers & Blockers

Script to  check the blocking session:

col "Lock Type" format a15

col "Mode Held" format a15

col "Blocking?" format a15

SELECT SUBSTR(TO_CHAR(session_id),1,5) "SID",

  SUBSTR(lock_type,1,15) "Lock Type",

SUBSTR(mode_held,1,15) "Mode Held",

SUBSTR(blocking_others,1,15) "Blocking?"

FROM dba_locks  where blocking_others='Blocking';

Happy Learning..!!
Cheers..!!