Re: Oracle 9i-10g init.ora parameters

On 30 okt, 11:33, raja <dextersu..._at_gmail.com> wrote:
> 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.

I don't know why you ask anyone to provide an abstract from the migration and upgrade and the new features manual. Isn't it possible for you to consult the relevant documentation? All of your questions can be looked up easily in various documents, which I mentioned.

--
Sybrand Bakker
Senior Oracle DBA