Query to find inactive JDBC sessions older than two days

 Please find the query to find the inactive JDBC sessions older than two days. 

col username FOR a10 
col program FOR a25 
col process FOR a7 
col s_program FOR a20 
col MODULE FOR a20 
col spid FOR a9 
SELECT p.username, 
       p.program, 
       s.username, 
       s.status, 
       s.MODULE, 
       s.server, 
       s.process, 
       s.program s_program, 
       s.sid, 
       s.serial#, 
       p.spid, 
       s.logon_time 
FROM   v$session s, 
       v$process p 
WHERE  p.addr = s.paddr 
       AND s.logon_time < SYSDATE - 2 
       AND s.status = 'INACTIVE' 
       AND s.MODULE LIKE '%JDBC%' 
ORDER  BY process; 

Comments