Inactive Program
Inactive Program SELECT p.spid,s.sid,s.last_call_et / 3600 last_call_et_Hrs,s.status,s.action,s.MODULE,s.program,t.disk_reads,Lpad(t.sql_text, 30) “Last SQL”FROM … Read more
Apps DBA
Inactive Session Details More Than 1 Hour
Inactive Session Details More Than 1 Hour set pagesize 40col … Read more
Total Inactive Sessions Group By Module
Total Inactive Sessions Group By Module col program FOR a30col … Read more
Toral Inactive Sessions More Than 1Hour
Toral Inactive Sessions More Than 1Hour col program FOR a30col … Read more
Inactive Programs With Disk Reads Prompt Inactive Sessions
Inactive Programs With Disk Reads Prompt Inactive Sessions SELECT DISTINCT … Read more
Inactive Programs
Inactive Programs col MODULE FOR a40prompt inactive sessionscol inactive_programs FOR … 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 … Read more
Total Count Of Sessions Ordered By Action
Total Count Of Sessions Ordered By Action col action FOR … Read more
Total Count Of Sessions Ordered By Module
Total Count Of Sessions Ordered By Module col MODULE FOR … Read more
Total Sessions Count Ordered By Program
Total Sessions Count Ordered By Program col program for a30col … Read more