오라클 CONNECT BY PRIOR
|
1 2 3 |
SELECT * FROM TABLE START WITH 기준칼럼 = ‘값’ CONNECT BY PRIOR 자식칼럼 = 기준칼럼; |
오라클 락(Lock) 세션 확인, 락 해제
1. 락 세션 확인
|
1 2 3 4 5 6 7 |
SELECT a.sid, a.serial# FROM v$session a , v$lock b , dba_objects c WHERE a.sid =b.sid AND b.id1 =c.object_id AND b.type=’TM’; |
2. 락 세션 해제
|
1 2 3 |
ALTER system kill session ‘sid, serial#’; COMMIT; |