CODE EXAMPLE FOR SQL

kill session inactive oracle

select 'ALTER SYSTEM KILL SESSION '''||SID||','||SERIAL#||''' IMMEDIATE;' from v$session where status <> 'ACTIVE';