Flashback Estimation Queries

1. The following query will give you some important details as mentioned below,

SQL> Select * from v$flashback_database_log;

The oldest_flashback_scn and the oldest_flashback_time columns indicate how far you can flash back your database.

The flashback_size and estimated_flashback_size columns indicate the space usage by the flashback logs.

The retention_target column lets you know the retention period for the flashback logs.

2. To estimate how much space the flashback logs consume at various point of time (hour by hour progress)

SQL> Select * from V$flashback_database_stat order by begin_time;

Thanks