Re: top things to watch out for when migrating from 9i r2 to 10g r2

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 10 Apr 2006 23:26:48 +0200
Message-ID: <iajl325gvc2f94ci9qn7rful8hn0jcqcp7@4ax.com>

On Mon, 10 Apr 2006 17:02:00 -0400, NetComrade <netcomradeNSPAM_at_bookexchange.net> wrote:

>I am in the early stages of studying the migration path to 10gr2.
>
>Anything particular to watch out for?
>
>I kind of recall that 10g now automatically collects table index
>statistics?
>
>Thanks,
>Andrey
>.......
>We run Oracle 9.2.0.6 on RH4 AMD
>remove NSPAM to email

Flash recovery area
autobackup
rman behavior changes

Statistics are collected automagically but you can turn that of or reschedule.

A course is too expensive at your site?

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Apr 10 2006 - 16:26:48 CDT