List All Undo Datafiles With Status And Size
List All Undo Datafiles With Status And Size show parameter … Read more
tutorailwale
To Check When a Table is Last Analysed
To Check When a Table is Last Analysed SELECT owner,table_name,tablespace_name,status,last_analyzed,partitioned,dependencies,droppedFROM … Read more
List All Datafile Of Undo Tablespace
List All Datafile Of Undo Tablespace SELECT tablespace_name,file_name,file_id,autoextensible,bytes / 1048576 … Read more
Undo Space Used By All Transactions
Undo Space Used By All Transactions set lines 200col sid … Read more
List Of Long Running Queries
List of long running queries set head OFFSELECT ‘LIST OF … Read more
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
Datewise Occurrence Of ORA-1555
Datewise Occurrence Of ORA-1555 SELECT To_char(begin_time, ‘mm/dd/yyyy hh24:mi’) “Int. Start”,ssolderrcnt … 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