Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] Online rebuild index danger or NOT???
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.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 22 2007 - 17:43:58 CDT
![]() |
![]() |