找到死锁的sid
SELECT T.session_id||',' FROM dba_ddl_locks t WHERE t.owner='XXXX' AND UPPER(NAME)='ORP_x_xx';
生成删除进程语句 --IMMEDIATE 可控制立即释放资源
SELECT 'alter system kill session '''||SID||','||SERIAL#||'''IMMEDIATE;' FROM v$session WHERE SID IN (4190,
1772,
1832,
4074,
4190,
1772,
1832,
4074);
如果进程仍一直锁住,可登录数据库服务器(linux) kill -9处理:
select SPID from v$process where ADDR in (select paddr from V$SESSION WHERE SID=2426) ; kill session -9 SPID;