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; |
0개의 댓글