Re: Index Rebuild Tuning

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 19 Aug 2004 07:40:06 -0700
Message-Id: <1092926406.1219.142.camel@poirot>

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_at_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
-----------------------------------------------------------------

Received on Thu Aug 19 2004 - 09:43:32 CDT