Re: Chained Rows

From: Oliver Stratmann <yxcsstratmoqwert_at_gmx.de>
Date: Thu, 4 Mar 2004 10:57:17 +0100
Message-ID: <c26uhu$1p67sn$1@ID-180535.news.uni-berlin.de>

I think Dr Drudge is aiming the phrase "The default value of 10 leaves 90% of each block empty."
If this is right we are in severe trouble here. But I think "PCTFREE 10" leaves 10 % of each block empty for updates and Dr Drudge is right here.

Thanks anyway!
We are still testing!

Bye!
Oli
"Daniel Morgan" <damorgan_at_x.washington.edu> schrieb im Newsbeitrag news:1078333540.580692_at_yasure...
> Dr Drudge wrote:
>
> > Isn't the explanation of PCTFREE wrong on that PSOUG page?
>
> I sure hope not ... it was copied directly from otn.oracle.com.
>
> > It states:
> >
> > "Tables on which there are no updates should have PCTFREE set to 0.
>
> PCTFREE of 0 means the block is never removed from the list of free
> blocks until it is completely filled. If there will never be any
> updates there is no reason to leave empty space in the block.
>
> One removes a block prior to being filled so that there is room,
> within the block, for additional information added to the rows
> by an update.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Thu Mar 04 2004 - 03:57:17 CST