On 10/6/05, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
>
> nologging will also speed it up
>
Amir,
not if the database (or that tablespace) has FORCE LOGGING enabled.
DGdba
> *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.
>
>
--
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 06 2005 - 15:26:41 CDT