[오라클] lock 오브젝트 조회 및 lock 해제하기

01. Lock 확인
-------------------------------------------
SELECT A.SESSION_ID SID
    ,B.SERIAL# SERIAL_NO
    ,A.OS_USER_NAME
    ,A.ORACLE_USERNAME
    ,B.STATUS
FROM V$LOCKED_OBJECT A
  ,V$SESSION B
WHERE A.SESSION_ID = B.SID;

02. Lock 걸린 session 죽이기
-------------------------------------------
ALTER SYSTEM KILL SESSION 'SID, SERIAL_ID';