徐万新之路spool kill_latch_holder.log
set feedback off
set head off
select 'kill -9 ' || p.spid ||'' PROCESS_ID_NEED_KILL from v$session s, v$process p where s.paddr = p.addr and s.sid in ( select sid from v$session where event like 'enq: TX - allocate ITL entry%' or event like 'library cache%');
spool offkilllatch.sql
未经允许不得转载：徐万新之路 » killlatch.sql
