RE: alter index rebuild online
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: <mark.powell@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 Oct 2005 15:07:41 -0500
I will try parallel as Mike Kurth suggested. Thank you all.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark D
Sent: Thursday, October 06, 2005 3:02 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kennedy, Jim
Sent: Thursday, October 06, 2005 3:53 PM
To: roger_xu@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu
Sent: Thursday, October 06, 2005 12:49 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx
For technical support please email tech_support@xxxxxxxxxxx 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@xxxxxxxxxxxx
Other related posts:
