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: Table allocates space on empty columns?

Re: Table allocates space on empty columns?

From: Grt <grt_post_at_hotmail.com>
Date: Sun, 31 Jan 1999 04:17:26 +0100
Message-ID: <36B3CB46.C73FC7F7@hotmail.com>



You should read about PCTFREE instead, I presume.

grt

Tom Pall wrote:

Be careful about columns which are empty upon insert but have data
placed in them during updates.  This can result in chained rows, which
degrades performance.   If rows are updated so that there is not enough
room in the block to hold them, Oracle will continue a row in the next
block.  If your application inserts rows with empty columns which are
later filled, read about using PCTINCREASE in the Server Concepts manual
to avoid this.
Received on Sat Jan 30 1999 - 21:17:26 CST

Original text of this message

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