Managing Undo Data

Beginning with Oracle Database 11g, for a default installation, Oracle Database automatically manages the undo data. There is typically no need for database administrator (DBA) intervention. However, if your installation uses Oracle Flashback operations, then you may have to perform some undo management tasks to ensure the success of these operations.

This section provides background information and instructions for managing undo data. It contains the following topics:

• About Undo Data

• About Managing Undo Data

• Viewing Undo Information

• Computing the Minimum Undo Tablespace Size Using the Undo Advisor

• Changing the Undo Tablespace to a Fixed Size

• Changing the Datafiles for an Undo Tablespace to a Fixed Size

• Changing Undo Management Analysis Parameters

• Switching Undo Tablespaces