Undo Advisor(OEM)


You can use Undo Advisor to set UNDO_RETENTION and the required undo tablespace size.

You can open the Undo Advisor using the Database-> Diagnose-> Undo Advisor (OEM) tabs via TOAD as follows.


You can alter the existing Undo tablespace as follows.


You can change the undo retention time as follows.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *