오라클 락 확인
SELECT C.OBJECT_NAME AS OBJECT_NAME,
A.SESSION_ID AS SESSION_ID,
B.SERIAL# AS SERIAL_NO,
A.OS_USER_NAME AS OS_USER_NAME,
B.machine AS machine,
A.ORACLE_USERNAME AS ORACLE_USERNAME,
B.STATUS AS STATUS
FROM V$LOCKED_OBJECT A, V$SESSION B, DBA_OBJECTS C
WHERE A.SESSION_ID = B.SID AND A.OBJECT_ID = C.OBJECT_ID
해제
ALTER SYSTEM KILL SESSION '세션아이디,오브젝트아이디'