Database Administration (MOSC)

MOSC Banner

Undo recommendation is confusing - Doc ID 1579035.1

edited Oct 26, 2015 10:01AM in Database Administration (MOSC) 1 commentAnswered

Ran the undo space/retention recommendation script from note - Script - Check Current Undo Configuration and Advise Recommended Setup (Doc ID 1579035.1).

The output is somewhat confusing:

-----------------------------------------------------

- Undo Analysis started at : 16/10/2015 09:58:42 -

--------------------------------------------------

NOTE:The following analysis is based upon the database workload during the period -

Begin Time : 09/10/2015 09:58:42

End Time   : 16/10/2015 09:58:42

Current Undo Configuration

--------------------------

Current undo tablespace                                 : ESUNDO01

Current undo tablespace size (datafile size now)        : 36864M

Current undo tablespace size (consider autoextend)      : 36864M

AUTOEXTEND for undo tablespace is                       : OFF

Current undo retention                                  : 7200

UNDO GUARANTEE is set to                                : FALSE

Undo Advisor Summary

---------------------------

Finding 1:Undo Tablespace is under pressure. Recommendation 1:Size undo tablespace to 2010 MB

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center