| 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: alter index rebuild online
no parallel: 42 minutes
with parallel 3: 29 minutes
Thanks
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu
Sent: Thursday, October 06, 2005 3: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.
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.
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.
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 06 2005 - 17:10:05 CDT
 |
 |