O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Automatic Undo Management

Oracle introduced automatic undo management in Oracle 9i. This feature has been significantly improved in Oracle Database 10g; in addition, the Undo Advisor tool has been introduced. To run your database in automatic undo management mode, you should set the UNDO_MANAGEMENT initialization parameter to AUTO.

Oracle makes a copy of the original data in the database before modifying it. This is helpful if you ever wish to roll back any database changes. Oracle writes these change vectors to undo the operation. The original copy of the data before any modification is called the undo data. This undo data is stored in an undo tablespace. The automatic undo management feature automatically determines the retention period ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required