13.4. Using Miscellaneous Space Management Tools
Two other automated space management features fall into the advisor category: the Undo Advisor and the Redo Logfile Size Advisor. In both cases, Oracle collects statistics on a continuous basis to help you size the undo tablespace and the online redo logs to enhance both performance and availability.
In the following sections, we'll show you how to manage the size of your undo tablespace using the Undo Advisor. After we present an overview of how online redo log files are configured and managed, we'll explain how the Redo Logfile Size Advisor can help you tune the configuration of your online redo log files.
13.4.1. Controlling Undo Space
Undo tablespaces are monitored just like any other tablespace: ...