2020. 6. 30. 17:13
오라클
SELECT /*+ RULE */ D.JOB, V.SID, V.SERIAL#, STATUS, LOG_USER USERNAME, WHAT, DECODE(TRUNC(SYSDATE - LOGON_TIME), 0, NULL, TRUNC(SYSDATE - LOGON_TIME) || ' Days' || ' + ') || TO_CHAR(TO_DATE(TRUNC(MOD(SYSDATE-LOGON_TIME,1) * 86400), 'SSSSS'), 'HH24:MI:SS') RUNNING, D.FAILURES, 'alter system kill session ' || '''' || V.SID || ', ' || V.SERIAL# || '''' || ' immediate;' KILL_SQL FROM DBA_JOBS_RUNNING D, V$SESSION V, DBA_JOBS J WHERE V.SID = D.SID AND D.JOB = J.JOB;
http://www.runningoracle.com/product_info.php?products_id=34
'오라클' 카테고리의 다른 글
| Oracle Lock 조회 (0) | 2020.12.24 |
|---|---|
| 오랫동안 실행중인 SQL(Find Long Run SQL ) (0) | 2020.04.28 |
| Temp TableSpace 사용량 확인 (0) | 2020.04.10 |
| lock tree 형식으로 조회 (0) | 2020.04.09 |
| Undo 사용량 확인 (0) | 2020.03.24 |