Re: Pre-Approved database changes

From: <Jared.Still_at_radisys.com>
Date: Thu, 17 Jun 2004 16:47:52 -0700
Message-ID: <OF5597C89D.BF013905-ON88256EB6.008278A5-88256EB6.0082B76D@radisys.com>

oracle-l-bounce_at_freelists.org wrote on 06/17/2004 04:05:18 PM:

>
> - deleting empty partitions/tablespaces
>
> - gathering statistics. This list has made it pretty clear that
> analyzing can cause "profoundly negative results". We have currently
> escaped tracking this since all of our analyze jobs are automated, but
> that will probably change the first time a major system has a slowdown
> and the only thing that has changed is a recent analyze and that was not
> tracked.
>

True, but I have no desire to try and document when it should and shouldn't
be done. This is one if the areas that will still require some DBA discretion.

I don't want to go to CC to get approval to generate stats for a single table
that has had a lot of DML activity and now gets a useless plan. Not too often
but it does happen occasionally.

Thanks,

Jared

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 17 2004 - 18:44:57 CDT