Re: PCTFREE=0 and updates

"Robert Eden" <rmeden_at_yahoo.com> wrote in message news:<0WXs8.77499$Bk1.2956268680_at_newssvr30.news.prodigy.com>...
> 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

Robert, column of type numeric result in variable size of storage requirements depending on their value, and even if all the columns were declared as type char and date (which is always 7 bytes) what happens if at some point in the future you need to add another column? I would suggest you set at least a small value for pctfree, say 3 - 5%.

IMHO -- Mark D Powell --

--
Mark D Powell - Unregistered User
------------------------------------------------------------------------
View this thread: http://homer-w2k:7802/baanboard/showthread.php?threadid=7606