lock tree 형식으로 조회

SELECT level,

LPAD('         ', (level-1)*2, '        ') || NVL(s.username, '(oracle)') AS username,

s.osuser,

s.sid,

s.serial#,

s.lockwait,

s.status,

s.module,

s.machine,

s.program,

TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time

FROM v$session s

WHERE level > 1

OR     EXISTS (SELECT 1

                    FROM v$session

                    WHERE blocking_session = s.sid)

CONNECT BY PRIOR s.sid = s.blocking_session

START WITH s.blocking_session IS NULL;

 

--출처

https://oracle-base.com/dba/script?category=10g&file=lock_tree.sql