you're taking statspack snapshots, you can also find the non-default
parameters captured in the statspack repository. I don't remember the
exact table in the STATS$ tables, but it shouldn't be that hard to find
if you're really desperate (and you're taking regularly-scheduled
Original Message ----
From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
Sent: Wednesday, August 8, 2007 8:43:04 AM
Subject: Re: History on dynamic parameters
There should be a record of the changes in the alert log if you can
find the entries from that far back.
On 8/8/07, jurgen_mortier@xxxxxxxx
I'm a junior DBA and I have an Oracle 18.104.22.168.0 running on Solaris 8
has been restarted on July 28th (by my collegue currently on FTO) to
- shared_pool_reserved_size= from 60M to 100 M
- shared_pool_size= from 600M to 1000M
- undo_retention= from 1800 to 3600
Since then users report that queries are running twice as long as
On August 2nd I tried to change back the last 2 parameters (since they
dynamic), but the CKPT process was consuming 1 complete CPU and I was
forced to reboot the system on the 3rd. At that time I changed the
parameters back to 600M and 1800 seconds.
Since that didn't improve the response time, I started realizing that
dynamic parameters might have been changed dynamically without the init
file being updated.
Does anyone know of a way to find back the history of those (dynamic)
parameters (accross DB restarts) ?
AMI Semiconductor - "Silicon Solutions for the Real World"
electronic message contains information that may be confidential or
privileged. The information is intended for the use of the individual
or entity named above. If you are not the intended recipient, please be
aware that any disclosure, copying, distribution or use of the contents
of this information is prohibited. If you received this electronic
message in error, please notify the sender and delete the copy you
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'