| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Index Rebuilds
I think if Oracle ever drops rule-based optimization as they keep
insisting they intend to do, the object stats have to be internally
done and not dependent on manual processes that customers may or may
not perform.
Kim Thompson
City and County of San Francisco
______________________________ Reply Separator _________________________________
Subject: RE: Index Rebuilds
Slightly off-topic here, but with all this talk of locking vs. no locking for analyzing tables etc., I wouldn't be surprised to see *all* of the "manual" table analysis disappearing in a not-too-distant version of Oracle. I don't have any inside information here, apart from the fact that I know a couple of people who have gone to work in the Optimizer Group at Oracle and their previous experience was with a database that keeps all of the table stats up to date (including histogram-type stuff) on the fly with little or no performance impact. So, remember where you heard it first!
(just my $0.01 [sic])
Colin.
-----Original Message-----
Sent: Friday, June 09, 2000 8:11 AM
To: Multiple recipients of list ORACLE-L
analyze for statistics never did an exclusive lock, it was validate structure that locked it.
index rebuild no longer locks the index....
>From: "Joseph S. Testa" <teci_at_oracle-dba.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Index Rebuilds
>Date: Fri, 09 Jun 2000 05:56:54 -0800
>
>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).
--
Author: Rachel Carmichael
INET: carmichr_at_hotmail.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:
INET: Colin.Shaw_at_phs.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
Received on Fri Jun 09 2000 - 16:09:00 CDT
 |
 |