| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
V$FLASHBACK_DATABASE_STAT displays statistics for monitoring the I/O overhead of logging flashback data. This view also displays the estimated flashback space needed based on previous workloads.
| Column | Datatype | Description |
|---|---|---|
BEGIN_TIME |
DATE |
Beginning of the time interval |
END_TIME |
DATE |
End of the time interval |
FLASHBACK_DATA |
NUMBER |
Number of bytes of flashback data written during the interval |
DB_DATA |
NUMBER |
Number of bytes of database data read and written during the interval |
REDO_DATA |
NUMBER |
Number of bytes of redo data written during the interval |
ESTIMATED_FLASHBACK_SIZE |
NUMBER |
Value of ESTIMATED_FLASHBACK_SIZE in V$FLASHBACK_DATABASE_LOG at the end of the time interval |
