Showing posts with label flashback logs. Show all posts
Showing posts with label flashback logs. Show all posts

Monday, June 9, 2014

Check the flashback logs information

1. check the flashback logs information.
SQL> select * from v$flashback_database_log;

OLDEST_FLASHBACK_SCN OLDEST_FL RETENTION_TARGET FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE
-------------------- --------- ---------------- -------------- ------------------------
             1158030 08-JUN-14             1440      104857600                 10641408