Friday , April 26 2024

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.

Loading

About 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 *

Categories