[오라클] 락 조회 및 삭제
1. 테이블명, Lock 상태 확인 SELECT T1.object_name, DECODE(locked_mode, 2, 'ROW SHARE', 3, 'ROW EXCLUSIVE', 4, 'SHARE', 5, 'SHARE ROW EXCLUSIVE', 6, 'EXCLUSIVE', 'UNKNOWN') lock_mode FROM dba_objects T1, v$locked_object T2 WHERE T1.object_id = T2.object_id; 2. 테이블 락 조회 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'; 3. 해당 세션 삭제 ..
더보기