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: Robert Eden <Guest.2xi0n_at_timelimit.pandora.be>
Date: Thu, 11 Apr 2002 04:39:44 GMT
Message-ID: <Guest.2xi0n@timelimit.pandora.be>

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 Eden - Unregistered User
------------------------------------------------------------------------
View this thread: http://homer-w2k:7802/baanboard/showthread.php?threadid=7606
Received on Wed Apr 10 2002 - 23:39:44 CDT

Original text of this message

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