Re: Oracle Chaining

Would a exp and and imp for the table achieve thhe same result as the "alter move"?

Thx

Matthias Hoys wrote:
> <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 - 16:19:59 CST