[ORACLE] ORA-00054 : resource busy and acquire with NOWAIT specified or timeout expired

 

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

라는 오류가 발생하여 수정, 삭제 등이 불가능 할 때 해결 방법

 

SELECT A.SID
     , A.SERIAL#
     , A.STATUS
  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 = '테이블명'
;

나오는 sid, serial# 
SQL> ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

로 세션 킬하고 처리