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.

![]()
Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 