오라클 락 해제, ORACLE LOCK

ORACLE LOCK 확인 후 해제

-- 테이블별확인

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'

AND C.OBJECT_NAME = UPPER('TABLE_NAME') --테이블명

ALTER SYSTEM KILL SESSION 'SESSION_ID, SERIAL#'

ALTER SYSTEM KILL SESSION '85, 1443'

-- 계정별 확인

SELECT A.SESSION_ID, B.SERIAL#

  FROM V$LOCKED_OBJECT A, V$SESSION B

 WHERE B.SID = A.SESSION_ID AND A.ORACLE_USERNAME = 'USER' --계정명