Total Inactive Sessions
Total Inactive Sessions prompt inactive sessionsSELECT p.spid,s.sid,s.last_call_et / 3600 last_call_et,s.status,s.action,s.MODULE,s.programFROM gv$session s,v$process pWHERE p.addr = s.paddrAND s.status = ‘INACTIVE’; prompt inactive sessionsSELECT Count(s.status) INACTIVEFROM gv$session … Read more