Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
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.
