Re: 10g upgrade survey--performance/stability

So with all the long discussion about how to upgrade (actually decided by your business requirement: downtime, dbsize mostly), anyone have something to summarize when it comes to performance area/stable in 10g after migrate to 10.2.0.3(our target version)?

We hit major issue when we upgrade from 8174 to 9205, mostly _library_cache_advice (controlled by statistics_level=typical in 9i as default), and latch free contention due to oralce code bug.

It would be great if someone can share such kind of messages. of course, this only apply to those who run real big and busy database system:)

On 3/7/07, LS Cheng <exriscer_at_gmail.com> wrote:
>
> So far I have always used manual, not because I dont like DBUA just that
> some places I go X doesnt work well so i ended up doing everything using
> ssh.
>
>
>
> On 3/5/07, Dennis Williams <oracledba.williams_at_gmail.com> wrote:
> >
> > List,
> >
> > If you've upgraded more than one database to 10g, please let me know
> > what method you chose:
> >
> > 1. dbua
> > 2. Manual upgrade
> > 3. Created a 10g database and migrated the data.
> >
> > Either reply to the list or to me directly. Also please let me know why
> > you chose the path you selected and if you had to do it again if you'd done
> > it differently.
> >
> > Thanks,
> > Dennis Williams
> >
>
>

-- 
Regards
Zhu Chao
www.cnoug.org

--
http://www.freelists.org/webpage/oracle-l