oracle错误ORA-00054: resource busy and acquire with NOWAIT sp

Oracle杀死锁进程

先查看哪些表被锁住了:
1、获得sid
select b.owner,
       b.object_name,
       a.session_id,
       a.locked_mode from v$locked_object a,
       dba_objects b where b.object_id = a.object_id;

2、获得sid,serial
select b.username, b.sid, b.serial#, logon_time
  from v$locked_object a, v$session b
 where a.session_id = b.sid
 order by b.logon_time;

3、杀死锁进程
alter system kill session 'sid,serial';
如果有ora-00031错误，则在后面加immediate;
alter system kill session '29,5497' immediate；
--杀数据库进程（数据库服务器的机子）
SELECT a.username, c.spid AS os_process_id, c.pid AS oracle_process_id
  FROM v$session a, v$process c
 WHERE c.addr = a.paddr
   and a.sid ='1392'
   and a.serial# ='10858';