| 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: [Q] Online rebuild index danger or NOT???
First, what's the motivation for rebuilding your indexes at all? In general, regularly scheduled index rebuilds are a good way to keep DBAs busy and burn CPU and I/O, but probably don't buy you much. There are a few exceptions, though. Do a google search for "Rebuilding the truth" and "richard foote".
However, to answer your question, I can't think of any reason online rebuilds are dangerous. If the rebuild is justified, and you're on a production system, an online rebuild could really be a huge relief, not having to take down time. Ask your vendor to state a specific reason to avoid online rebuilds.
-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak_at_il.proquest.com
www.proquest.com
www.csa.com
ProQuest...Start here.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Monday, October 22, 2007 3:55 PM
To: oracle-l_at_freelists.org
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 - 16:02:05 CDT
 |
 |