Total Inactive Sessions Group By Module
Total Inactive Sessions Group By Module 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 … Read more