Oracle 9i-10g init.ora parameters

Hi,

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.

With Regards,
Raja. Received on Thu Oct 30 2008 - 05:33:46 CDT