| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index Rebuild Tuning
That might not be true. Our vendor had to re-write their code to allow us to
partition a table in their application. We had to partition because of bad
design so the vendor was sort of obliged to do the re-write. The vendor was
AMS.
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of David Kurtz
Sent: Thursday, August 19, 2004 11:43 AM
To: oracle-l_at_freelists.org
Subject: RE: Index Rebuild Tuning
...and why isn't the table partitioned?
Even if the vendor tools won't support it, why can't you partition it
manually?
BTW - which vendor?
regards
tel: +44 (0)7771 760660 fax: +44 (0)7092 348865 web: www.go-faster.co.uk
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fuad Arshad
Sent: 19 August 2004 14:07
To: oracle-l_at_freelists.org
Subject: Index Rebuild Tuning
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
 |
 |