Re: can i know old value for a parameter ?

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 14 Oct 2007 13:54:34 GMT
Message-ID: <47121f9a$0$31679$79c14f64@nan-newsreader-05.noos.net>

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. Received on Sun Oct 14 2007 - 08:54:34 CDT