I strongly suspect I'm missing something here, but I don't see a problem
with gathering stale many times a day, every hour say. If your tables
aren't subject to much DML activity then they won't be analysed anyway.
On Tue, 2003-12-30 at 12:59, Rachel Carmichael wrote:
> 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
> >
> --------------------------------------------------------------------------------
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly personal.
> > QOTD: Any clod can have facts, having an opinion is an art !
> >
> >
> **************************************************************************************
> > This e-mail message is confidential, intended only for the named
> > recipient(s) above and may contain information that is privileged,
> > attorney work product or exempt from disclosure under applicable law.
> > If you have received this message in error, or are not the named
> > recipient(s), please immediately notify corporate MIS at (860)
> > 766-2000 and delete this e-mail message from your computer, Thank
> > you.
> >
> **************************************************************************************4
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jamadagni, Rajendra
> > INET: Rajendra.Jamadagni_at_espn.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).
>
>
> __________________________________
> 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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Austin Hackett
INET: hacketta_57_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 - 07:59:25 CST
