Re: Oracle managed statistics
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Wed, 31 Oct 2007 14:17:35 -0700
Altus 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).
Fire the vendor.
There are times when stale statistics are the better. They are using
mythology to make decisions rather than real-world experience.
I would suggest getting a copy of Jonathan Lewis' book on the CBO
and reading it with care.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.
- References:
- Oracle managed statistics
- From: Altus
- Oracle managed statistics
- Prev by Date: Re: Oracle managed statistics
- Next by Date: Re: slow migration path
- Previous by thread: Re: Oracle managed statistics
- Index(es):
Relevant Pages
|
