Re: Oracle Chaining

aprinsloo_at_sagetelecom.net wrote:
> 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

Perhaps the pct_free only applies to newly added rows but you are having problems updating rows that are already there with the old pct_free?

jg

--
@home.com is bogus.
http://www.tomyang.net/cars/ferrari.html?http://www.tomyang.net/cars/story1.htm