Re: Index Rebuild Tuning
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Aug 2004 07:40:06 -0700
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
