romantic..._at_gmail.com 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.
If you have set up Statspack you can extract parameter history from
stats$parameter.
Similarly, if you are using AWR, you can extract parameter history
from dba_hist_parameter.
(In both cases history is kept only as long as you keep your
snapshots, of course).
Received on Mon Oct 15 2007 - 04:09:40 CDT
