Oracle Kill Inactive Session
1.Command to Kill Inactive Session SELECT * FROM v$session WHERE status =’INACTIVE’; select ‘alter system kill session ”’ ||sid|| ‘,’ ||serial#|| ”’ immediate;’ as insess from v$session where status=’INACTIVE’; commit; select ‘alter system kill session ”’ ||sid|| ‘,’ ||serial#|| ”’ immediate;’ from v$session where status=’INACTIVE’ and program is null and module is null;…