2020. 4. 9. 11:56
오라클
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
'오라클' 카테고리의 다른 글
| 오랫동안 실행중인 SQL(Find Long Run SQL ) (0) | 2020.04.28 |
|---|---|
| Temp TableSpace 사용량 확인 (0) | 2020.04.10 |
| Undo 사용량 확인 (0) | 2020.03.24 |
| ORACLE shrink 작업 (0) | 2020.03.02 |
| DBLink(DB Link 생성) (0) | 2019.08.22 |