Oracle杀死死锁进程

Oracle杀死死锁进程 先查看哪些表被锁住了:
select 
b.object_name,
a.session_id,
c.serial#,
a.locked_mode
from v$locked_object a,dba_objects b,v$session c
where b.object_id = a.object_id
and a.session_id = c.sid
and b.owner = 'NRMDB' ;

杀进程中的会话:
alter system kill session 'sid,serial#';

假如有ora-00031错误，则在后面加immediate;alter system kill session '29,5497' immediate；

 

若仍然被锁，请参看如下文档：

Oracle中Kill session的研究