Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Data Dictionary Information on Undo

The means by which to locate undo segment information in the data dictionary is discussed in this section.

• V$UNDOSTAT Provides statistics on undo data. You can use this view to determine how well the system is working. Each row in the view provides statistics collected in the instance at 10 minute intervals. You can use this view to help to determine how much undo space to estimate for your current workload. The database uses this view somewhat differently; it uses the view to tune undo usage in the system. The view is available for both automatic and manual undo management mode.

  The most recent row in the dynamic ...