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;’