79736

Computing the Minimum Undo Tablespace Size Using the Undo Advisor

If you must changc the undo tablespace to a fixed size, then usc the Undo Advisor to help determine the minimum rcquircd size. You can also usc the Undo Advisor to set the minimum undo retention period.

To configure the undo tablespace to have a fixed size, Oracle suggests that you first allow enough time after database creation to run a fuli workload, thus allowing the undo tablespace to grow to its minimum required size to handle the workload. Then, you can use the Undo Advisor to determine the best size to configure the undo tablespace to allow for futurę long-running queries and Oracle Flashback operations.