Frank van Bortel wrote:
> Oradba Linux schreef:
>> 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.
> Just wait a couple of weeks...
>
oh boy... You sound like a mystery novel.
Do you feel it will bloat back up to 12G again. I am sure it will
increase but by how much is the question. I will not have any deletes to
this table. Many concurrent inserts from data loads.
Received on Sun Feb 04 2007 - 08:11:16 CST
