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:
Post a Comment