Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Flashback database question
On Sep 26, 4:05 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <jackzh..._at_gmail.com> a écrit dans le message de news: 1190835448.931165.54..._at_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!
> |
>
> Oracle did not need to reuse space so it kept older transactions.
>
> Regards
> Michel
Thnx, but my question is since RETENTION_TARGET is 6 hours, does this mean I only can flashback database up to 6 hrs ago? If so, how come the OLDEST_FLASHBACK_TIME is way more than 6 hrs? Received on Wed Sep 26 2007 - 15:19:17 CDT