Find Total Undo Statistics

To Find Total Undo Statistics ALTER SESSION SET nls_date_format=’dd-mon-yy hh24:mi’; set lines 120set pages 2000SELECT begin_time,end_time,undoblks,txncount,maxquerylen,unxpstealcnt,expstealcnt,ssolderrcnt,nospaceerrcntFROM v$undostat; Total Undo Statistics since specified year SELECT ‘TOTAL … Read more