Message-ID: <F001.005DB44E.20031230081925@fatcity.com>
Date: Tue, 30 Dec 2003 08:19:25 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Rachel Carmichael <wisernet100@yahoo.com>
Subject: RE: Should we stop analyzing?
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I fold :)

--- Whittle Jerome Contr NCI <Jerome.Whittle@scott.af.mil> wrote:
> I'll see your 'analyzed every 4 hours' and raise you one. We have
> some tables that are analyzed every time they are used! They are
> 'work' tables that are sometimes empty, very full, or somewhere in
> between. Running something when the statistics say the table is full
> but actually is empty takes a little longer when CBO says use
> indexes; however, if CBO thinks the table is empty and does a FTS
> when there's actually a million records, well let's just say it takes
> a while. Hints work sometimes; however,  analyzing these table after
> they are populated and letting CBO do it's job usually works best.
> 
> Two points. 
> 
> First this particular database had not been analyzed for over a year
> when I got there and this database gets larger daily. They added
> indexes but it didn't make much difference. After analyzing, most
> things were much faster; however, the 'work' tables started acting up
> depending on their state when analyzed. We now analyze twice a month.
> 
> Second when it comes to these 'work' tables, I wasn't there and it
> wasn't my idea!
> 
> Jerry Whittle
> ASIFICS DBA
> NCI Information Systems Inc.
> jerome.whittle@scott.af.mil
> 618-622-4145
> 
> > -----Original Message-----
> > From:	Rachel Carmichael [SMTP:wisernet100@yahoo.com]
> > 
> > I have you beat.... one schema in one of our databases (9.2.0.2) is
> > analyzed every 4 hours. Not mine, and I *will* be talking to the
> DBA
> > about his reasoning...
> > 
> > however Jonathan's point may well be the reason. This is an
> > ever-growing database, frequent insert and updates, and sequences
> are
> > used throughout.
> >  Analyze is "estimate" at least. 
> > 
> > --- "Jamadagni, Rajendra" <Rajendra.Jamadagni@espn.com> wrote:
> > > Mogens, if you are looking for a poster boy ...
> > > 
> > > We analyze 9 production databases ... *every day*.
> > > Raj
> > 
> 


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100@yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).