Check inactive or idle session

select username, UPPER(program), logon_time, 
       floor(last_call_et / 60) "Minutes since active", status
from v$session
order by last_call_et;

Comments