Just share a sql below is about to find jdbc connections with idle for 8 days(28800/3600)
select username,sid,serial#, (sysdate - prev_exec_start)*24*3600 last_call_during from v$session where program like '%JDBC%' and event ='SQL*Net message from client'
and status = 'INACTIVE' and (sysdate - prev_exec_start)*24*3600 > 28800
No comments:
Post a Comment