Re: Flashback database question

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 26 Sep 2007 22:05:57 +0200
Message-ID: <46fabba7$0$4746$426a74cc@news.free.fr>

<jackzhunj_at_gmail.com> a écrit dans le message de news: 1190835448.931165.54480_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 Received on Wed Sep 26 2007 - 15:05:57 CDT