First page Back Continue Last page Graphics
Monitoring Flashback Database...
V$FLASHBACK_DATABASE_LOG can be used to
- Determine how far back flashback possible
- Estimate space requirements for your workload
Notes:
The new V$FLASHBACK_DATABASE_LOG dynamic performance view reveals some useful information about the state of flashback database and flashback log size requirements. For example, OLDEST_FLASHBACK_SCN and OLDEST_FLASHBACK_TIME reveal how far back the database can be flashed back. FLASHBACK_SIZE shows the amount of space currently being used by flashback data. ESTIMATED_FLASHBACK_SIZE shows how much space – given the current workload – is actually required to maintain 1440 minutes of retention.