Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!feeder.news-service.com!feeder.news-service.com!216.196.110.148.MISMATCH!border1.nntp.ams.giganews.com!nntp.giganews.com!newsfeeder.wxs.nl!hoboe2bl2.telenet-ops.be!kramikske.telenet-ops.be!nntp.telenet.be!skynet.be!newspost001!tjb!not-for-mail Reply-To: "Matthias Hoys" From: "Matthias Hoys" Newsgroups: comp.databases.oracle.server References: <1165959325.251501.186110@80g2000cwy.googlegroups.com> Subject: Re: Oracle Chaining Date: Tue, 12 Dec 2006 22:53:51 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-RFC2646: Format=Flowed; Original Lines: 24 Message-ID: <457f24f0$0$31466$ba620e4c@news.skynet.be> Organization: -= Belgacom Usenet Service =- NNTP-Posting-Host: a7402179.news.skynet.be X-Trace: 1165960432 news.skynet.be 31466 87.64.224.63:1453 X-Complaints-To: usenet-abuse@skynet.be Xref: usenetserver.com comp.databases.oracle.server:419059 X-Received-Date: Tue, 12 Dec 2006 16:53:53 EST (text.usenetserver.com) wrote in message news:1165959325.251501.186110@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