Multiple choice technology databases

What should you look at first to compute the number of undo blocks that are consumed and estimate the size of the undo tablespace needed to handle the workload on your system?

  1. UNDOSTAT

  2. ROLLSTAT

  3. TRANSACTION

  4. DBA_UNDO_EXTENTS

  5. DBA_ROLLBACK_SEGS

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The UNDOSTAT view in Oracle provides statistics on undo consumption, including undo block consumption rates. This is the primary view to analyze when sizing undo tablespaces. It helps estimate how much undo space your workload requires based on historical usage patterns.