Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PCTFREE=0 and updates

Re: PCTFREE=0 and updates

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Apr 2002 18:54:36 +0200
Message-ID: <vdr8bukj4l60vgjle3ki7u794to84sad1f@4ax.com>


On Wed, 10 Apr 2002 14:23:56 GMT, "Robert Eden" <rmeden_at_yahoo.com> wrote:

>If I only update statically sized columns in a table ( NUMBER, CHAR (not
>VARCHAR)) can I sent PCTFREE to 0 to avoid the (default) 10% waste? (no
>nulls involved)
>
>The Oracle docs aren't clear on the types of operations that change "row
>size".
>
>Robert
>

number is not statically sized.
Any operation that would make any column at least one byte longer will affect the rowsize.
Decreasing PCTFREE to 0 will likely result in chained rows (ie rows in more than 1 Oracle block)
The effect of chaining on performance is big enough to avoid reducing PCTFREE to 0. Please reconsider.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 10 2002 - 11:54:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US