RE: alter index rebuild online

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Thu, 6 Oct 2005 16:15:46 -0400
Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C00268CB0A@usa0300ms03.na.xerox.net>

nologging will also speed it up

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu
Sent: Thursday, October 06, 2005 4:08 PM To: mark.powell_at_eds.com; oracle-l_at_freelists.org Cc: mkurth_at_wfs-ops.org
Subject: RE: alter index rebuild online

I will try parallel as Mike Kurth suggested. Thank you all.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark D

	Sent: Thursday, October 06, 2005 3:02 PM
	To: oracle-l_at_freelists.org
	Subject: RE: alter index rebuild online
	
	
	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.

For technical support please email tech_support_at_dp7uptx.com or you can

	call (972)721-8257. 
	This email has been scanned for all viruses by the MessageLabs

Email Security System.

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:21:07 CDT