Oracle 9i-10g init.ora parameters
Date: Thu, 30 Oct 2008 03:33:46 -0700 (PDT)
I have a database, which was recently migrated from 9i to 10g. Current Version : 10.2.0.3.0
I checked some of the init.ora parameters in current 10g database.
They were as follows :
optimizer_mode : choose statistics_level : typical timed_statistics : TRUE
From the above init.ora parameter values, i found that they looked to be the values of 9i version.
My doubt is :
1. If we migrate from 9i to 10g, whether the init.ora parameters will set according to the default values of 10g automatically (or)
will we have to change these settings manually ? 2. What does this mean, that a 10g database (10.2.0.3.0), still having the default values of 9i init.ora parameter values ? 3. Also, please add the comparison of the default init.ora parameters between oracle 9i and 10g ?
Please clarify my doubts.
Thanks in Advance.
Raja. Received on Thu Oct 30 2008 - 05:33:46 CDT