Managing UNDO Data
About the Undo Retention Period
UNDO_RETENTION The default is 900s Which is 15m
The user A should see the data as 10:00 exactly And this is called read consistency
User B - This will not reflect the user A query, User A still see the old data, because he execute the query at 10:00 am
'Database > Oracle' 카테고리의 다른 글
| 105 - [Oracle 19C] Flashback table and Flashback Version Query (0) | 2023.12.19 |
|---|---|
| 104 - [Oracle 19C] Categories of Undo (0) | 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 |
| 100 - [Oracle 19C] Comparing Undo Data and Redo Data (0) | 2023.12.18 |
