dba_undo_extents

Oracle Undo: Check Extent Status in DBA_UNDO_EXTENTS Purpose A report query runs for forty minutes on a busy system and ends with ORA-01555: snapshot too old. The query is correct. The undo it needed to build a consistent picture of the data was overwritten before the query finished. Somewhere between the size of the …