What should you look at first to computer the number of undo blocks that are consumed and estimate the size of the undo tablespace needed to handle the workload on your system?
A.
V$UNDOSTAT
B.
V$ROLLSTAT
C.
V$TRANSACTION
D.
DBA_UNDO_EXTENTS
E.
DBA_ROLLBACK_SEGS
Explanation:
V$UNDOSTAT Contains statistics for monitoring and tuning undo space. Use this view to help estimate the amount of undo space required for the current workload. The database also uses this information to help tune undo usage in the system. This view is meaningful only in automatic undo management mode.
REF.: Oracle(r) 10g Administrator Guide, 10-10