| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
V$FLASHBACK_DATABASE_LOG displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.
| Column | Datatype | Description |
|---|---|---|
OLDEST_FLASHBACK_SCN |
NUMBER |
Lowest system change number (SCN) in the flashback data |
OLDEST_FLASHBACK_TIME |
DATE |
Time of the lowest SCN in the flashback data |
RETENTION_TARGET |
NUMBER |
Target retention time (in minutes) |
FLASHBACK_SIZE |
NUMBER |
Current size (in bytes) of the flashback data |
ESTIMATED_FLASHBACK_SIZE |
NUMBER |
Estimated size of flashback data needed for the current target retention |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
