What is the UNDO_MANAGEMENT parameter?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the UNDO_MANAGEMENT parameter?
Rating:
UNDO_MANAGEMENT is an initialization parameter that is set in the
The syntax of the UNDO_MANAGEMENT parameter is given below:
The default value of the UNDO_MANAGEMENT parameter is MANUAL.
The parameter class of UNDO_MANAGEMENT is
The UNDO_MANAGEMENT parameter specifies the mode of undo space management used by the system.
If the UNDO_MANAGEMENT parameter mode is set to AUTO, then the instance starts in automatic mode of undo management but if it is set to MANUAL mode, then the undo space is allocated externally as rollback statements.
Rating:
Was this information helpful?
Other articles
- What is the SHUTDOWN ABORT statement?
- What is a statement failure?
- What is STARTUP command?
- What is an initialization parameter file?
- OCA 1z0-042 Short Notes: Exam passing tips