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;
若仍然被锁,请参看如下文档: