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 -> PCTFREE=0 and updates

PCTFREE=0 and updates

From: Robert Eden <rmeden_at_yahoo.com>
Date: Wed, 10 Apr 2002 14:23:56 GMT
Message-ID: <0WXs8.77499$Bk1.2956268680@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
Received on Wed Apr 10 2002 - 09:23:56 CDT












Original text of this message













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