Re: PCTFREE=0 and updates

Robert Eden 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

As well as some other arguments, you can end up with an artificial locking scenarion because of insufficient space for ITL's. Maybe go with 1

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."