col MODE_REQUESTED for a14
col MODE_HELD for a20
col LOCK_ID1 for a10
SELECT session_id
, lock_type
, mode_held
, mode_requested
, blocking_others
, lock_id1
FROM dba_lock l
WHERE lock_type NOT IN ('Media Recovery', 'Redo Thread')
/
Sample Output:
Code: Select all
SESSION_ID LOCK_TYPE MODE_HELD MODE_REQUESTED BLOCKING_OTHERS LOCK_ID1
---------- -------------------------- -------------------- -------------- ---------------------------------------- ----------
165 XR Null None Not Blocking 4
165 Control File Row-S (SS) None Not Blocking 0
158 RF Row-S (SS) None Not Blocking 2
165 RS Row-S (SS) None Not Blocking 25
158 RF Row-S (SS) None Not Blocking 5
158 RF Row-S (SS) None Not Blocking 6
167 PW Row-X (SX) None Not Blocking 1
164 Temp Segment Row-X (SX) None Not Blocking 3