Re: can i know old value for a parameter ?

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 14 Oct 2007 02:21:58 GMT
Message-ID: <a3fQi.85$qO6.30@newsfe06.phx>

z1hou1 <z1hou1_at_gmail.com> wrote in news:1192315963.070529.220830 @i13g2000prf.googlegroups.com:

> Hi, I think it is stored in the dictionary view V
> $FLASHBACK_DATABASE_LOG.
>
> z1hou1
>

With free advice, you get what you paid for it.

SQL> desc v$flashback_database_log

 Name                                      Null?    Type
 ----------------------------------------- -------- 
----------------------------
 OLDEST_FLASHBACK_SCN                               NUMBER
 OLDEST_FLASHBACK_TIME                              DATE
 RETENTION_TARGET                                   NUMBER
 FLASHBACK_SIZE                                     NUMBER
 ESTIMATED_FLASHBACK_SIZE                           NUMBER

Perhaps, the Magic EightBall has the answer. Received on Sat Oct 13 2007 - 21:21:58 CDT