Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Chapter 11. Managing Undo Data

Terms you'll need to understand:

• Rollback

• Undo

• UNDO_MANAGEMENT

• UNDO_TABLESPACE

• UNDO_RETENTION

• UNDO_SUPPRESS_ERRORS

• V$UNDOSTAT

• V$ROLLNAME

• V$ROLLSTAT

• V$TRANSACTION

• V$SESSION

• DBA_ROLLBACK_SEGS

• CREATE UNDO TABLESPACE

Concepts you'll need to master:

• Describe the purpose of undo data.

• Implement automatic undo management.

• Create and configure undo segments.

• Obtain undo segment information from the data dictionary.

Historically, Oracle has used rollback segments to manage space dedicated to providing the ability to undo a transaction. This method (rollback segments) is now referred to as manual undo management mode. Manual undo management mode is still supported under all compatibility levels. You can still use this method when you are ...