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.

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

See Also:

Chapter 15, "Using Oracle-Managed Files"for information about creating an undo tablespace whose datafiles are both created and managed by Oracle Database.