Multiple choice technology databases

What should you look at to compute the number of undo blocks written per second on disk ?

  1. V$UNDOSTAT
  2. V$TRANSACTION
  3. V$ROLLSTAT

  4. DBA_UNDO_EXTENTS

  5. DBA_ROLLBACK_SEGS
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

V$UNDOSTAT provides undo statistics including undo blocks written, which can be used to calculate blocks per second. It tracks undo usage over time intervals. V$TRANSACTION shows current transactions but not historical rates. V$ROLLSTAT shows rollback segment statistics but not per-second rates. DBA_UNDO_EXTENTS shows extent allocation, not write rates. DBA_ROLLBACK_SEGS shows rollback segment configuration, not activity.

Keep practicing — related questions