oracle资源正忙 但指定,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