Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index Rebuilds
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).