| 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: Rebuilding Indexes Question
re-building online was carried out for one of our huge indexes. It took lots of resouces and slowed down the system performance. The operation had to be cancelled. Though users can still carry out transactions against the concerned table, Oracle uses other resources which may impact the over all system performance. It is still better to do it in off hours.
rgds
amar
-----Original Message-----
From: Joe Testa [mailto:teci_at_the-testas.net]
Sent: Tuesday, October 23, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Rebuilding Indexes Question
and in 9i, almost everything is done online, w/journaling and no locking.
but thats another week in the future. ;)
joe
Charlie Mengler wrote:
>
> >From 1st hand experience, folks need to be warned that
> the last time I did this during normal working hours on an
> index on a production table, the order entry department
> could no longer commit new orders. They were "hung"
> until the index rebuild completed. So use with caution.
>
> Deepak Thapliyal wrote:
>
> > Jacques
> >
> > i think oracle puts exclusive locks on the table on
> > which you are trying to create an index. that reason
> > should be good enough to use the "rebuild online"
> > option instead of create/drop especially for systems
> > that require to be available all the time
> >
> > Deepak
> >
> > --- Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
> > wrote:
> > > > -----Original Message-----
> > > > From: cjordan_at_smcwv.com [mailto:cjordan_at_smcwv.com]
> > > >
> > > > What are the advantages/disadvantages to doing a
> > > alter index rebuild
> > > > (Oracle 8.0.X) versus dropping and recreating the
> > > index.
> > >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.com
-- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: teci_at_the-testas.net 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 Tue Oct 23 2001 - 00:05:19 CDT
 |
 |