If you want to kill all inactive sessions in the database, it is hard to find and kill one by one. Use below statement to create kill statements at a time and run them to kill all inactive session.
select 'alter system kill session '||sid||','||serial#|| ';' from v$session where status='INACTIVE';
No comments:
Post a Comment