Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index Rebuild Tuning
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 <jkstill_at_cybcon.com> 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
-- 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_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 - 10:26:12 CDT
![]() |
![]() |