RE: Index Rebuild Tuning
- From: "David Kurtz" <info@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Aug 2004 16:43:22 +0100
...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
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk
mailto:david.kurtz@xxxxxxxxxxxxxxx
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Fuad Arshad
Sent: 19 August 2004 14:07
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
