ORA-00054: resource busy and acquire with NOWAIT specified

1.select object_name, s.sid, s.serial#, p.spid from v$locked_object l, dba_objects o, v$session s, v$process pwhere l.object_id = o.object_id and l.session_id = s.sid and s.paddr = p.addr;2.alter system kill session `'sid,serial#';

---

http://stackoverflow.com/questions/3075738/ora-00054-resource-busy-and-acquire-with-nowait-specified