Re: Migrating to cost based optimizer

On Sun, 24 Sep 2006 20:06:24 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>> My instinct is always to hire qualified DBAs and make running StatsPack
>> or AWR frequently part of their job requirement.
>
> I think it's a good bet that there will always be a few oddities,
> but if you (or your client) starts with a legacy data load and
> do proper UAT, then the anomalies and places where the
> stats need to be adjusted should show up early. But it does
> help to have an experienced reviewer checking what's going
> on and predicthing threats.

=

What would you say about 3rd party maintenance routinely (every day) collecting stats, and NOT saving the old stats in a stats table?

--
Sybrand Bakker, Senior Oracle DBA