Inactive Programs
Inactive Programs col MODULE FOR a40prompt inactive sessionscol inactive_programs FOR … Read more
Apps DBA
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
Count Of Active Sessions
COUNT OF ACTIVE SESSIONS SELECT Count(s.status) ACTIVE_SESSIONSFROM gv$session s,$process pWHERE … Read more
Sessions Which Are In Inactive Status From More Than 1 HOUR
Sessions Which Are In Inactive Status From More Than 1 … Read more
SQL Queries to Check Active or Inactive Sessions
SQL Queries to Check Active or Inactive Sessions Total Count … Read more
Query To Find Database Redolog Temp And Control File Size
Query To Find Database Redolog Temp And Control File Size … Read more
Query To Find Database Size
Query To Find Database Size QUERY TO FIND DATABASE SIZESELECT … Read more