Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!j44g2000cwa.googlegroups.com!not-for-mail
From: aprinsloo@sagetelecom.net
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle Chaining
Date: 12 Dec 2006 14:19:59 -0800
Organization: http://groups.google.com
Lines: 30
Message-ID: <1165961999.047054.205610@j44g2000cwa.googlegroups.com>
References: <1165959325.251501.186110@80g2000cwy.googlegroups.com>
   <457f24f0$0$31466$ba620e4c@news.skynet.be>
NNTP-Posting-Host: 216.65.195.52
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1165962004 7273 127.0.0.1 (12 Dec 2006 22:20:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 22:20:04 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; FunWebProducts; .NET CLR 2.0.50727; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: j44g2000cwa.googlegroups.com; posting-host=216.65.195.52;
   posting-account=yqIbeg0AAABHr2v80j1sXhjeMiHOq9vC
Xref: usenetserver.com comp.databases.oracle.server:419067
X-Received-Date: Tue, 12 Dec 2006 17:20:04 EST (text.usenetserver.com)

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

Thx



Matthias Hoys wrote:
> <aprinsloo@sagetelecom.net> 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