Oracle 세션·락 확인 및 해제

세션 확인

SELECT SID, SERIAL#, USERNAME, PROGRAM
FROM V$SESSION;

락 걸린 테이블

SELECT
  S.SID, S.SERIAL#, S.USERNAME,
  O.OBJECT_NAME, S.OSUSER, S.PROGRAM
FROM V$LOCKED_OBJECT L
LEFT JOIN DBA_OBJECTS O ON L.OBJECT_ID = O.OBJECT_ID
LEFT JOIN V$SESSION S ON L.SESSION_ID = S.SID
ORDER BY S.SID, O.OBJECT_NAME;

세션 해제

ALTER SYSTEM KILL SESSION 'sid,serial#';
-- 예: ALTER SYSTEM KILL SESSION '123,45678';