Oradba Linux wrote:
> We are running a 4 node RAC on RHEL 3.0. We have a table with 300mil
> rows that has an pk index upto 12Gb and we rebuilt it it came down to
> 6g. The data into this table was loaded with concurrent inserts from
> different sessions. This table is on ASSM tablespace. Same thing with
> many other indexes.
Given it is a RAC cluster I must ask ...
What type of index?
Does the primary key include the instance identifier?
What performance metric indicates the rebuild is accomplishing anything?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Feb 04 2007 - 11:16:22 CST
