To Check Space Related Statistics Of Undo Tablespace
To Check Space Related Statistics Of Undo Tablespace selectsum(ssolderrcnt) ‘Total … Read more
tutorailwale
To Check Space Related Statistics Of Undo Tablespace
To Check Space Related Statistics Of Undo Tablespace SELECT undoblks,begin_time,maxquerylen,unxpstealcnt,expstealcnt,nospaceerrcntFROM … Read more
To Show Undo Retention Value
To Show Undo Retention Value Show parameter undo_retention; Undo retention … Read more
Extent Count And Total Blocks
Extent Count And Total Blocks set linesize 152col tablespace_name FOR … Read more
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