I fold :)
- Whittle Jerome Contr NCI <Jerome.Whittle_at_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_at_scott.af.mil
> 618-622-4145
>
> > -----Original Message-----
> > From: Rachel Carmichael [SMTP:wisernet100_at_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_at_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_at_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_at_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).
Received on Tue Dec 30 2003 - 10:19:25 CST
