Inactive Programs With Disk Reads Prompt Inactive Sessions

Inactive Programs With Disk Reads Prompt Inactive Sessions SELECT DISTINCT (s.program) INACTIVE_PROGRAMS,SUM(T.disk_reads)FROM gv$session s,gv$sqlarea t,v$process pWHERE s.sql_address=t.addressAND s.sql_hash_value=t.hash_valueAND p.addr=s.paddrAND s.status=’INACTIVE’GROUP BY S.program; Read More Articles … Read more