解决办法:
查询锁表情况:
select o.object_name, machine, s.action,s.TERMINAL, s.sid, s.serial# from v$locked_object l, dba_objects o, v$session s
where l.object_id= o.object_id and l.session_id = s.sid;
强制解锁:
alter system kill session ‘1020,16863‘; -- (分别是上面查询出的sid,serial#)
ora-00054:resource busy and acquire with NOWAIT specified
原文:http://www.cnblogs.com/apple2016/p/5692854.html