Undo recommendation is confusing - Doc ID 1579035.1
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