处理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