Re: Double Underscore Sign In Parameters....
Date: Sat, 11 Oct 2008 05:21:05 -0700 (PDT)
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.
srivenu Received on Sat Oct 11 2008 - 07:21:05 CDT