ORA-00054错误

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

 

查找并解决死锁：

select object_name,session_id,oracle_username from v$locked_object t1, user_objects t2 where t1.object_id =t2.object_id;

select sid, serial#, username, osuser , * from v$session where sid='374';

alter system kill session '374,38633';

 

如果还不行的话，尝试‘alter system disconnect session '374,38633' immediate;’