RE: alter index rebuild online

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 6 Oct 2005 16:01:52 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395BB2C@usahm236.amer.corp.eds.com>

Based on the few times I used the command one of the best ways to speed up an "alter index x rebuild online" is to issue the command when no DML is taking place. DML activity slows the processing down. Just using "alter index x rebuild" will normally be faster and for larger objects the difference is noticable. It may not be an option for use but if you have a reason to rebuild an index it is best to do so during a maintenance window or when the object is not being used.

Mark D Powell --

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kennedy, Jim
Sent: Thursday, October 06, 2005 3:53 PM To: roger_xu_at_dp7uptx.com; oracle-l_at_freelists.org Subject: RE: alter index rebuild online

Don't do it?
Faster IO?
Faster CPU?
More paralelzation?
Where's the bottleneck?
Jim

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu
Sent: Thursday, October 06, 2005 12:49 PM To: oracle-l_at_freelists.org
Subject: alter index rebuild online

How do I speed up this? (9.2.0.4.0)

Thanks,

Roger Xu

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.

This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.

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

Received on Thu Oct 06 2005 - 15:06:16 CDT