[ORACLE] Lock 걸려있는 table 세션 kill

ORA-00054: resource busy and acquire with NOWAIT specified

세션확인

select b.spid, a.*

from v$session a, v$process b

where a.paddr = b.addr

;

세션 킬

alter system kill session 'SID, SERIALI#'