Active
Uncommitted undo information
required if a user wants to roll back or if the transaction has failed.
Uncommitted undo information is never overwritten.
Unexpired
Committed undo information
Old undo information with an age that is less than the current undo retention period retained for consistent read and Oracle Flashback operations
Expired
Expired undo information
Old (committed) undo information that is older than the current undo retention period is said to be expired and its space is available to be overwritten by new transactions.
'Database > Oracle' 카테고리의 다른 글
| 106 - [Oracle 19C] Automatic Tuning of Undo Retention, example (0) | 2023.12.19 |
|---|---|
| 105 - [Oracle 19C] Flashback table and Flashback Version Query (0) | 2023.12.19 |
| 103 - [Oracle 19C] About the Undo Retention Period (1) | 2023.12.19 |
| 102 - [Oracle 19C] Overview of Automatic Undo Management (0) | 2023.12.19 |
| 101 - [Oracle 19C] Local Undo Mode vs Shared Undo Mode (0) | 2023.12.18 |
