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

The V$UNDOSTAT view provides statistics on undo tablespace usage, including undo blocks written per second. This dynamic performance view is specifically designed for monitoring undo space consumption and helps track undo block write rates to disk.

Keep practicing — related questions