V$UNDOSTAT- Definition - Oracle Tablespaces

Q.  Which view is useful for monitoring the effects of transaction execution on undo space in the current instance in viewing information about undo?
- Published on 03 Aug 15

a. V$UNDOSTAT
b. V$ROLLSTAT
c. V$TRANSACTION
d. DBA_UNDO_EXTENTS

ANSWER: V$UNDOSTAT
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - You can obtain information from the views available for viewing tablespace and datafile information

    - The following dynamic performance views are useful for obtaining space information about the undo tablespace:

    - 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.

    - V$ROLLSTAT - For automatic undo management mode, information reflects behavior of the undo segments in the undo tablespace

    - V$TRANSACTION - Contains undo segment information

    - DBA_UNDO_EXTENTS - Shows the status and size of each extent in the undo tablespace.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)