SQL query to find Inactive Session

 

set linesize 200
set pages 200
col username format a15
col idle format a15
col program format a30
select
sid,username,status,
to_char(logon_time,'dd-mm-yy hh:mi:ss') "LOGON",
floor(last_call_et/3600)||':'||
floor(mod(last_call_et,3600)/60)||':'||
mod(mod(last_call_et,3600),60) "IDLE",
program
from
v$session where STATUS='INACTIVE' order by LOGON;