Monday, June 9, 2014

Displaying statistics of flashback log generation

1.Displaying statistics on the flashback logs genereated with an interval of 1 hour.
SQL> select begin_time,end_time,redo_data,db_data,estimated_flashback_size from v$flashback_database_stat;

BEGIN_TIM END_TIME   REDO_DATA    DB_DATA ESTIMATED_FLASHBACK_SIZE
--------- --------- ---------- ---------- ------------------------
09-JUN-14 09-JUN-14    1254400    3137536                        0
09-JUN-14 09-JUN-14      99840    3416064                  8282112

No comments: