14 Managing Undo

Beginning with Release 11g, for a default installation, Oracle Database automatically manages undo. There is typically no need for DBA intervention. However, if your installation uses Oracle Flashback operations, you may need 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:

• What Is Undo?

• Introduction to Automatic Undo Management

• Setting the Minimum Undo Retention Period

• Sizing a Fixed-Size Undo Tablespace

• Managing UndoTablespaces

• Migrating to Automatic Undo Management

• Undo Space Data Dictionary Views