[DB] 테이블 Lock 해제

SELECT A.SESSION_ID, B.SERIAL# FROM V$LOCKED_OBJECT A, V$SESSION B WHERE B.SID = A.SESSION_ID AND A.ORACLE_USERNAME = '계정명'; 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 ('테이블명'); ALTER SYSTEM KILL SESSION 'SID, SERIAL#';...