System Managed Undo

From Oracle FAQ
Jump to: navigation, search

System Managed Undo (SMU) is a database feature that allows the database to create and manage UNDO segments by itself. To enable SMU, set the UNDO_MANAGEMENT parameter to TRUE.


The following parameters can be set to control SMU:

  • undo_management - Instance runs in SMU mode if TRUE, else in RBU mode.
  • undo_tablespace - use/switch undo tablespace
  • undo_retention - undo retention in seconds

Also see[edit]

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #