Re: Double Underscore Sign In Parameters....
From: <srivenu_at_hotmail.com>
Date: Sat, 11 Oct 2008 05:21:05 -0700 (PDT)
Message-ID: <fe75bb8a-87c0-4412-a15a-0f501c325fda@v13g2000pro.googlegroups.com>
Date: Sat, 11 Oct 2008 05:21:05 -0700 (PDT)
Message-ID: <fe75bb8a-87c0-4412-a15a-0f501c325fda@v13g2000pro.googlegroups.com>
As michael said, oracle automatically adjusts the dynamic parameters
as per instance load. (from 10g. Automatic shared memory management)
The values that oracle comes up with could be different from what you
have supplied at the starting of the instance or the defaulted values.
If you use a pfile, these deduced values are lost during the next
reboot and oracle will again have to repeat the process to deduce the
best values for the given workload.
If you use a spfile, this can be avoided as the values are preserved
with a double underscore and will be used to set values for thos
parameters duing the the next startup.
regards
srivenu
Received on Sat Oct 11 2008 - 07:21:05 CDT