Re: [Q] Online rebuild index danger or NOT???

You don't need to kick off users for online rebuild except the table is very busy(table is so hot that you can't get exclusive lock at any time).

We did this many times on production system in off-peak time. It's safe for most cases.

On 10/23/07, Amar Kumar Padhi <amar.padhi_at_gmail.com> wrote:
>
> We have mission critical systems, where we do have offpeak times to do
> maintenance. These are huge systems on 9i and rebuild of some indexes took
> more than couple of hours. We once did rebuild of few indexes during peak
> hours to switch the tablespace.
>
> Though users could continue to work, We noticed that users actually
> complained of performance when we performed online rebuild. We checked and
> realised that the process took high cpu utilization and affected other
> processes. Stopping the rebuild bought things back to normal.
>
> If ever required, we now schedule rebuild offline. Your vendor may be
> speaking from this point but don't kick out users, rather schedule in
> offpeak times.
>
> thanks!
> amar kumar padhi
> www.amar-padhi.com
> pushed from PDA
>
>
> -----Original Message-----
> From: "dba1 mcc" <mccdba1_at_yahoo.com>
> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> Sent: 23-10-07 00:34
> Subject: [Q] Online rebuild index danger or NOT???
>
> We have ORACLE 10gr2 on Redhat server. Our
> application vendor told me don't "online rebuild
> index". They suggest kick out all users then rebuild
> index.
>
> I have been online rebuild index on several databases
> since ORACLE 8.1.7 and NO problem.
>
> I don't know why application vendor suggest don't
> "online rebuild index". I like listen your
> experience.
>
> Thanks.
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Eagle Fan

Oracle DBA

--
http://www.freelists.org/webpage/oracle-l