Search notes:

Oracle: V$TEMPUNDOSTAT

select
   begin_time,
   end_time,
   undotsn,
   txncount,
   maxconcurrency,
   maxquerylen,
   maxqueryid,
   undoblkcnt,
   extcnt,
   uscount,
   ssolderrcnt,
   nospaceerrcnt,
   con_id
from
   v$tempundostat
order by
   end_time desc;

See also

temporary undo
dynamic performance views

Index