Re: alter index rebuild online
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: Amir.Hameed@xxxxxxxxx
- Date: Thu, 6 Oct 2005 16:22:02 -0400
On 10/6/05, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote:
>
> nologging will also speed it up
>
Amir,
not if the database (or that tablespace) has FORCE LOGGING enabled.
DGdba
------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Roger Xu
> *Sent:* Thursday, October 06, 2005 4:08 PM
> *To:* mark.powell@xxxxxxx; oracle-l@xxxxxxxxxxxxx
> *Cc:* mkurth@xxxxxxxxxxx
> *Subject:* RE: alter index rebuild online
>
> 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
>
>
--
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
Other related posts:
