Oracle Undo Segment AWR Report Section

Oracle Tips by Burleson Consulting

Undo Segment Summary Section

This section provides summary information about undo segments usage by Oracle. In this section, one can see how evenly Oracle distributes work between undo segments as along with statistics about the undo errors that occurred.

Undo Segment Stats Section

This section helps identify possible time periods when extra rollback activity occurred in the database. This could be very useful when the DBA has identified that the database sometimes experiences a large number of rollbacks. This section can help find exact times when such an activity took a place.

Also see my notes on undo management:

SEE CODE DEPOT FOR FULL SCRIPTS

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.

You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.