Database Administration & Monitoring, Oracle Query V$UNDOSTAT for relevant time window 30.09.2015 by Oracle Team By Franck Pachot . When you have a query failing in 'ORA-01555: snapshot too old: rollback segment number ... with name ... too small' you have two things to do: Convince the developer that the rollback segment is not too(…)