To Check Space Related Statistics Of Undo Tablespace

To Check Space Related Statistics Of Undo Tablespace selectsum(ssolderrcnt) ‘Total ORA-1555s’, round(max(maxquerylen)/60/60) ‘Max Query HRS’, SUM(unxpstealcnt) ‘UNExpired STEALS’,SUM(expstealcnt) ‘Expired STEALS’FROM v$undostatORDER BY begin_time; Read More … Read more

To Check Space Related Statistics Of Undo Tablespace SELECT undoblks,begin_time,maxquerylen,unxpstealcnt,expstealcnt,nospaceerrcntFROM stats$undostatWHERE begin_time BETWEEN SYSDATE – 90 AND SYSDATEAND unxpstealcnt > 0; Read More Articles To … Read more