Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Flashback database question
10.2.0.3
SQL> select sysdate from dual;
SYSDATE
SQL> select OLDEST_FLASHBACK_TIME,RETENTION_TARGET from v $flashback_database_log;
OLDEST_FLASHBACK_TI RETENTION_TARGET
------------------- ---------------- 09/24/2007 23:53:12 360
Since RETENTION_TARGET is 360 (6 hours), how come the OLDEST_FLASHBACK_TIME can be way beyond 6 hours?
Thanks! Received on Wed Sep 26 2007 - 14:37:28 CDT