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;
commit;

Add Comment