tutorailwale

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

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

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

Inactive Programs

Inactive Programs col MODULE FOR a40prompt inactive sessionscol inactive_programs FOR a40SELECT DISTINCT ( s.program ) INACTIVE_PROGRAMS,s.MODULEFROM gv$session s,v$process pWHERE p.addr=s.paddrAND s.status=’INACTIVE’; Read More Articles Total … Read more

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

Total Count Of Sessions Ordered By Action

Total Count Of Sessions Ordered By Action col action FOR a30prompt total sessionsSELECT s.action,Count(s.sid) Total_SessionsFROM gv$session s,v$process pWHERE p.addr = s.paddrGROUP BY s.action; Read More … Read more

Total Count Of Sessions Ordered By Module

Total Count Of Sessions Ordered By Module col MODULE FOR a30prompt total sessionsSELECT s.MODULE,Count(s.sid) Total_SessionsFROM gv$session s,v$process pWHERE p.addr = s.paddrGROUP BY s.MODULE; Read More … Read more

Total Sessions Count Ordered By Program

Total Sessions Count Ordered By Program col program for a30col Total_Sessions for 45SELECT s.program,Count(s.program) Total_SessionsFROM gv$session s,v$process pWHERE p.addr = s.paddrGROUP BY s.program; Read More … Read more

Count Of Active Sessions

COUNT OF ACTIVE SESSIONS SELECT Count(s.status) ACTIVE_SESSIONSFROM gv$session s,$process pWHERE p.addr = s.paddrAND s.status = ‘ACTIVE’; Read More Articles Sessions Which Are In Inactive Status … Read more