Re: Oracle Chaining

From: Matthias Hoys <anti_at_spam.com>
Date: Tue, 12 Dec 2006 22:53:51 +0100
Message-ID: <457f24f0$0$31466$ba620e4c@news.skynet.be>

<aprinsloo_at_sagetelecom.net> wrote in message news:1165959325.251501.186110_at_80g2000cwy.googlegroups.com...
> Oracle 9i standard.
>
> Ive noticed by looking at DBA_TABLES that some tables have excessive
> CHAIN_CNT, the highest been 3266085 on a 45 million row table.
> I've set the pct_free to 35 up from 10 but the CHAIN_CNT continues to
> climb, is there anything else I can try ?
>
> Thx in advance
>

The pct_free change will only affect new blocks. The increase you are seeing is for existing blocks that get updated. Permanent solution : rebuild the whole table with a higher pct_free with ALTER TABLE ... MOVE ... However, you will need enough temporary space for this operation + you will need to rebuild the table indexes and recalculate the stats afterwards. Good luck :-)

Matthias Received on Tue Dec 12 2006 - 15:53:51 CST