Re: Oracle managed statistics
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Thu, 01 Nov 2007 00:06:06 -0700
Altus wrote:
On Oct 31, 5:17 pm, DA Morgan <damor...@xxxxxxxxx> wrote:Altus wrote:Once again I turn to the gurus.Fire the vendor.
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).
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
damor...@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
- Show quoted text -
Not a chance!!!!
If I read a book, I may want to do things in a 9i or 10g way, rather
than the way they want (Oracle 8).
As far as stale being better, there is a table with one row which
never changes. Guess if they want it analyzed. Guess... I dare yah.
<grin>
thanks for the sympathy guys.
Unless you are 60+ years old holding out for a pension ... I'd recommend
updating your skills, updating your cv, and getting out of there before
your skill set deteriorates to the point that your next job includes
saying "Do you want fries with that?" (1/2 * <g>)
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.
- References:
- Re: Oracle managed statistics
- From: Altus
- Re: Oracle managed statistics
- Prev by Date: Opening for Oracle DBA
- Next by Date: Re: Why Oracle creates two shared memory segments instead of one?
- Previous by thread: Re: Oracle managed statistics
- Next by thread: Re: Oracle managed statistics
- Index(es):
Relevant Pages
|
