List Of Long Running Queries
List of long running queries set head OFFSELECT ‘LIST OF … Read more
Apps DBA
Undo Tablespace Utilization By All Sessions
Undo Tablespace Utilization By All Sessions set lines 200col sid … Read more
SQL Query To Check Active Transactions
SQL Query To Check Active Transactions set head ONSELECT usn,extents,Round(rssize … Read more
To Check Space Related Statistics Of Undo Tablespace
To Check Space Related Statistics Of Undo Tablespace selectsum(ssolderrcnt) ‘Total … Read more
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
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