Selasa, 10 Maret 2015

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

Below SQL will find your process

SELECT s.inst_id,
   'ALTER SYSTEM KILL SESSION '''||s.sid||','||s.serial#||''';' hasil,
   p.spid,
   s.username,
   s.program FROM   gv$session s
   JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id order by s.program;
Then kill it
ALTER SYSTEM KILL SESSION 'sid,serial#';
OR
some example I found online seems to need the instance id as well alter system kill session '130,620,@1';