DanBrother的部落格

--------------------------------------------
--   create views of oracle locks:
--------------------------------------------
conn /@ as sysdba
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/utllockt.sql

-------------------------------------
-- Display Locking Status:
-------------------------------------
col "SID" format a12
col "Lock Type" format a20
col "Mode Held" format a20
col "Blocking?" format a20

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;

View also V$LOCKED_OBJECT; DBA_WAITERS