오라클 락(Lock) 세션 확인, 락 해제

1. 락 세션 확인

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’;

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. 락 세션 해제

ALTER system kill session ‘sid, serial#’;

COMMIT;

ALTER system kill session ‘sid, serial#’;

COMMIT;

카테고리: Oracle

관련 글