15 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.

In this chapter:

• What Is Undo?

• Introduction to Automatic Undo Management

• Setting the Minimum Undo Retention Period

• Sizing a Fixed-Size Undo Tablespace

• Managing Undo Tablespaces

• Migrating to Automatic Undo Management

• Undo Space Data Dictionary Views