Specifying the Method of Undo Space Management

Every Oracle Database must have a method of maintaining information that is used to undo changes to the database. Such information consists of records of the actions of transactions, primarily before they are committed. Collectively these records are called undo data.

red hat certified system administrator rhcsa malaysia

To set up an environment for automatic undo management using an undo tablespace.

agile project management certification training courses malaysia

• Set the UNDO_MANAGEMENT initialization parameter to AUTO, which is the default.

• UNDO_MANAGEMENT Initialization Parameter
  The UNDO_MANAGEMENT initialization parameter determines whether an instance starts in automatic undo management mode, which stores undo in an undo tablespace. Set this parameter to AUTO to enable automatic undo management mode. AUTO is the default if the parameter is omitted or is null.

Microsoft windows server certification training courses malaysia

• UNDO_TABLESPACE Initialization Parameter
  The UNDO_TABLESPACE initialization parameter enables you to override that default undo tablespace for an instance.

red hat certified specialist in red hat enterprise Linux diagnostics and troubleshooting malaysia