Please find the query to find the 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
Post a Comment