oracle删除死锁进程
在命令行下运行:
select SID,SERIAL# from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
alter system kill session'36,6632';
在命令行下运行:
select SID,SERIAL# from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
alter system kill session'36,6632';