Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Flashback database question

Flashback database question

From: <jackzhunj_at_gmail.com>
Date: Wed, 26 Sep 2007 19:37:28 -0000
Message-ID: <1190835448.931165.54480@57g2000hsv.googlegroups.com>


10.2.0.3

SQL> select sysdate from dual;

SYSDATE



09/26/2007 15:02:07

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US