select * from v$session
where username = 'ABSSOLUTE' and STATUS = 'INACTIVE'


select 'ALTER SYSTEM KILL SESSION ''' || sid || ',' || serial# || '''' || ' IMMEDIATE;' from V$SESSION WHERE USERNAME = 'ABSSOLUTE' and STATUS = 'INACTIVE';