Re: can i know old value for a parameter ?

On Oct 14, 9:54 am, Jerome Vitalis
<vitalismanN05..._at_gmail.com.invalid> wrote:
> On Sat, 13 Oct 2007 15:34:22 -0700, romantic973 wrote:
> > hi all,
> > let's say a parameter changed in the database ex:
> > alter system set retention_target=1500; and i want to know what was the
> > old value before it has been changed , is there any way to know?
> > thanks for reading.
>
> Not always. But if the previous value was set by means of an 'alter
> system' command and if it's still in the alert.log (or in the previous
> ones if you rotate the file and keep its previous versions), you will see
> it by searching 'ALTER SYSTEM SET retention_target' in the alert<SID>.log
> file.

While Oracle does not maintain a history of database parameter values in the database it does list non-default values in the alert log as part of the startup message. In some cases this might provide the desired value though it is possible for dynamic values to have been changed more than once since the last startup.

For static parameters that have been changed with a scope=spfile only you could try comparing the value in v$spparameter against the value in v$parameter for the same parameter name.

HTH -- Mark D Powell -- Received on Sun Oct 14 2007 - 14:22:16 CDT