ORA-00054: resource busy and acquire with NOWAIT specified

第一:查询正在被锁的对象
SELECT /*+ rule */
 lpad(' ', decode(l.xidusn, 0, 3, 0)) || l.oracle_username User_name,
 o.owner,
 o.object_name,
 o.object_type,
 s.sid,
 s.serial#,
 s.logon_time
 FROM v$locked_object l, dba_objects o, v$session s
 WHERE l.object_id = o.object_id
    AND l.session_id = s.sid
 ORDER BY o.object_id, xidusn DESC;第二:如果允许KILL掉会话;
第三:操作正常;