oracle/plsql 进程锁死处理

 

处理plsql 进程锁死问题；

在command window中运行一下sql

set echo off
set heading off
set feedback off
set verify off

spool kill_lock_session.sql

select 'alter system kill session '||''''||sid||','||serial#||''''||';'
FROM v$session
WHERE process in ( select distinct process from v$locked_object );
spool off
@kill_lock_session.sql

set heading on
set feedback on