Oracle 报错ORA－00054：资源正忙，要求指定NOWAIT

处理步骤如下：

查看被锁的表和引起锁表的session：

select b.owner,b.object_name,a.session_id,a.locked_mode 
from v$locked_object a,dba_objects b
where b.object_id = a.object_id

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

select xidusn,object_id,session_id, oracle_username,os_user_name 
from v$locked_object ;

select object_id,object_name 
from dba_objects 
where object_id=‘145943’

alter system kill session '25,1' ;

select a.spid,b.sid,b.serial#,b.username,b.status from v$process a,v$session b where a.addr=b.paddr

在windows cmd.exe執行orakill oracle_instance spid