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 V$UNDOSTAT view (or UNDOSTAT) contains historical statistics to monitor and estimate the undo space requirements and transaction workloads on an Oracle database.