Re: Oracle managed statistics

On Oct 31, 12:00 pm, Altus <silverb...@xxxxxxxxxxxxxx> wrote:
Once again I turn to the gurus.

I have a vendor who is nervous about the Oracle managed statistics
(target object auto). They don't like seeing objects with statistics
older than a month.

My choices are:
1) Fight a battle "re: are the statistics REALLY stale".
This will be long and futile, since management likes vendors.
2) Change the frequency/agressiveness of the auto analyze.
3) Run the full analyze every day/week/2 weeks.
Waste of resources / 8i way of doing things.

Since I haven't played with the statistics area of GRID or 10g, I
would like to take that approach.

Is there a way to adjust Oracle's threshold?

Thanks,

Evan

Oracle 10.2.0.3 on Red Hat 3.
Three node RAC.

GRID shows the script as:
begin
dbms_stats.gather_database_stats(
options=> 'GATHER AUTO');
end;

Last night it analyzed 222 objects in 8.46 minutes. This left 899
tables and 1553 indexes analyzed before September 22 (vendor has a
tizzy).

I don't have much experience with this, but see
http://www.freelists.org/archives/oracle-l/08-2005/msg00564.html

I think the vendor may have a point, in that gather auto may be
incorrect in some fundamental assumptions, as I infer from Wolfgang's
comments there. But I may be way off base, and I sure don't want to
put words in anyones mouth. oracle-l has had many discussions about
this, google oracle statistics gather auto site:freelists.org
(although the past few days I've had to hit the browser back button to
see the results???)

jg
--
@home.com is bogus.
"The year of Linux is long passed." - CmdrTaco

.