To Show Undo Retention Value
To Show Undo Retention Value Show parameter undo_retention; Undo retention … Read more
Apps DBA
To Show ACTIVE/EXPIRED/UNEXPIRED Extents of Undo Tablespace
To Show ACTIVE/EXPIRED/UNEXPIRED Extents of Undo Tablespace SELECT tablespace_name,status,Count(extent_id) “Extent … Read more
To Check Retention Guarantee For Undo Tablespace
To Check Retention Guarantee For Undo Tablespace SELECT tablespace_name,status,CONTENTS,logging,retentionFROM dba_tablespacesWHERE … Read more
Inactive JDBC Sessions
Inactive JDBC Sessions set pagesize 50col inst_id FOR 99col spid … Read more
Inactive Modules
Inactive Modules 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
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
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