I analyze (estimate statistic) my application's schema every hour during
batch processing. It helps performance to do it and we have had no negative
consequences.
Ruth
----- Original Message -----
From: Joseph S. Testa <teci_at_oracle-dba.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Friday, June 09, 2000 9:56 AM
Subject: Re: Index Rebuilds
> most definitely, if i remember correctly, u can analyze a table and its
> doesnt do an exclulsive lock on it(maybe my brain is fuzzy too as i've
been
> on xml stuff for days).
>
> we used almost exclusively cost based now. 8.0, wtahc out for 8.1.5 bug ,
> divide by zero error if you analyze a table with no rows in it(estimate,
> compute works fine).
>
> we have some batch programs that run m-f in evening and we are 24x7, so we
> analyze tables based on what we think is the least impact(since it does
take
> up cpu cycles).
>
> hth, joe
>
>
> cyril wrote:
>
> > Hello!
> >
> > I am 'really surprised' that the solution 'commonly' provided for 'such
> > problems' is analyze the table..
> >
> > Do people really analyze tables? ( I mean do u get so much down time!
if
> > not how do u manage it!)
> > Do people really run their applications in COST BASED mode...
> > cos our organisation has been using Oracle6 onwards and since then the
> > applications have been tuned
> > for rule based and recently we tried to move to COST BASED and since
all
> > the programs gave a huge problem
> > we cried off...
> >
> > Has anyone gone from RULE BASED to COST BASED.. can u help!
> >
> > --
> > Author: cyril
> > INET: cyril_at_stockholding.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
>
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 Fri Jun 09 2000 - 09:03:10 CDT
