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 statistics on undo tablespace usage including undo blocks written per second. This dynamic performance view contains one row for each 10-minute interval and shows various undo metrics including transaction activity and space consumption. V$TRANSACTION shows active transactions, V$ROLLSTAT shows rollback segment statistics, and DBA_UNDO_EXTENTS shows undo extent information but not the per-second write rate.

Keep practicing — related questions