抄袭自：http://www.cnblogs.com/maomaoBlog/archive/2010/11/10/1873885.html

?

ORA-00054: resource busy and acquire with NOWAIT specified

?

1.查询被锁对象：

select object_name,machine,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;

2.将查找的被锁会话结束：

alter system kill session '130,5946'; (其中24,111分别是上面查询出的sid,serial#)