System Managed Undo
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
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.
Parameters
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
- Rollback Segment - Rollback Managed Undo (RMU)
| 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 | # |
