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 dynamic performance view contains statistics for monitoring the effects of undo space management, including the number of undo blocks consumed (UNDOBLKS) in 10-minute intervals. This data allows administrators to calculate the rate of undo blocks written per second. Other views do not provide this specific time-series undo block data.

Keep practicing — related questions