Toral Inactive Sessions More Than 1Hour

Toral Inactive Sessions More Than 1Hour col program FOR a30col inactive_programs FOR a40SELECT s.program,Count (s.program) Inactive_Sessions_from_1HourFROM gv$session s,v$process pWHERE p.addr=s.paddrAND s.status=’INACTIVE’AND s.last_call_et > (3600)GROUP BY … Read more