Oracle报 ORA-00054资源正忙的解决办法

## 在sqlplus中执行
select t2.username, t2.sid, t2.serial#, t2.logon_time from v$locked_object t1, v$session t2 where t1.session_id = t2.sid order by t2.logon_time;

alter system kill session '167,5185';

## 如果杀不掉就执行下面命令
select spid, osuser, s.program from v$session s, v$process p where s.paddr = p.addr and s.sid =167;

##在linux上，  退出sqlplus 执行
kill -9 22467 

##在windows上
orakill orcl 12345