From oracle-l-bounce@freelists.org Thu Oct 6 14:56:50 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j96Judnj007086 for ; Thu, 6 Oct 2005 14:56:44 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j96Ju7vX006948 for ; Thu, 6 Oct 2005 14:56:12 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 80F051F54CD; Thu, 6 Oct 2005 14:55:15 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32176-07; Thu, 6 Oct 2005 14:55:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F12011F50C8; Thu, 6 Oct 2005 14:55:14 -0500 (EST) x-mimeole: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5CAAF.9539EA33" Subject: RE: alter index rebuild online Date: Thu, 6 Oct 2005 12:53:11 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: alter index rebuild online Thread-Index: AcXKrvUK6zyicDLtT9K4/qG6aGeP0QAAIdhg From: "Kennedy, Jim" To: , X-OriginalArrivalTime: 06 Oct 2005 19:53:12.0500 (UTC) FILETIME=[956D8F40:01C5CAAF] X-archive-position: 26489 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jim_kennedy@mentor.com Precedence: normal Reply-To: jim_kennedy@mentor.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.5 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5CAAF.9539EA33 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Don't do it? Faster IO? Faster CPU? More paralelzation? Where's the bottleneck? Jim ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Roger Xu Sent: Thursday, October 06, 2005 12:49 PM To: oracle-l@freelists.org Subject: alter index rebuild online How do I speed up this? (9.2.0.4.0) =20 Thanks, =20 Roger Xu=20 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.=20 ____________________________________________________________________ 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@dp7uptx.com. ------_=_NextPart_001_01C5CAAF.9539EA33 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Don't do it?
Faster IO?
Faster CPU?
More paralelzation?
Where's the bottleneck?
Jim


From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Roger=20 Xu
Sent: Thursday, October 06, 2005 12:49 PM
To:=20 oracle-l@freelists.org
Subject: alter index rebuild=20 online

How do = I speed up=20 this? (9.2.0.4.0)
 
Thanks,
 

Roger Xu =


This=20 e-mail is intended solely for the person or entity to which it is = addressed and=20 may contain confidential and/or privileged information. Any review,=20 dissemination, copying, printing or other use of this e-mail by persons = or=20 entities other than the addressee is prohibited. If you have received = this=20 e-mail in error, please contact the sender immediately and delete the = material.=20
____________________________________________________________________<= BR>This=20 email has been scanned for all viruses by the MessageLabs Email Security = System.=20 Any questions please call 972-721-8257 or email your request to=20 tech_support@dp7uptx.com.
------_=_NextPart_001_01C5CAAF.9539EA33-- -- http://www.freelists.org/webpage/oracle-l