killlatch.sql

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 off