IDENTIFY THE INVALID SESSIONS AT DATABASE LEVEL

TO IDENTIFY THE INVALID SESSIONS AT DATABASE LEVEL
------------------------------------------------------------------------------------------

SQL > select 'alter system kill session'||''''||sid||','||serial#||''''||';' from v$session where status like 'INACTIVE';