From oracle-l-bounce@freelists.org Thu Aug 19 10:26:12 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i7JFQCt30327 for ; Thu, 19 Aug 2004 10:26:12 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i7JFQCI30322 for ; Thu, 19 Aug 2004 10:26:12 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D2A6772CF1A; Thu, 19 Aug 2004 10:30:21 -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 25093-26; Thu, 19 Aug 2004 10:30:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E611172CE05; Thu, 19 Aug 2004 10:29:52 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 19 Aug 2004 10:28:20 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ACEAB72CCB7 for ; Thu, 19 Aug 2004 10:28:19 -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 20169-76 for ; Thu, 19 Aug 2004 10:28:19 -0500 (EST) Received: from web80510.mail.yahoo.com (web80510.mail.yahoo.com [66.218.79.80]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 9AFA272CCBF for ; Thu, 19 Aug 2004 10:28:18 -0500 (EST) Message-ID: <20040819152917.1855.qmail@web80510.mail.yahoo.com> Received: from [63.73.199.69] by web80510.mail.yahoo.com via HTTP; Thu, 19 Aug 2004 08:29:17 PDT Date: Thu, 19 Aug 2004 08:29:17 -0700 (PDT) From: Fuad Arshad Subject: Re: Index Rebuild Tuning To: oracle-l@freelists.org In-Reply-To: <1092926406.1219.142.camel@poirot> MIME-Version: 1.0 Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 7893 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: fuadar@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org i knew this question was coming. its not a rebuild per say. we're doing a full data migration which includes dropping off indexes and then after completing column and data migration recreating the index. as far as logging database is archivelog but nologging on table level and on the index. Jared Still wrote: Looks like I get to be the first to ask: Why are you rebuilding the index? Jared On Thu, 2004-08-19 at 06:07, Fuad Arshad wrote: > Scenario > 1.8 Billion rows table non partitioned. > index key 30 bytes > parallel 8 on index parallel 2 on table > Oracle 9.2.0.4 > Workarea_size set to manual sort_area_size set to 100M > > Tablespace locally managed non assm > > The table is not partitioned because of vendor requirement > the rebuild is taking 12 hrs and is still runing . > > > need help tuning this rebuidl > it is not an online rebuild. > we are doing migration testing on a test box. even though production is 2wice as faster > thisis not acceptable with the users. > need advise. > the index size is around 57G ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------