Re: Problem in setting PCTFREE and PCTUSED

Are you deleting ALL records before the load? If so, why not truncate instead?

Are you deleting, inserting, or updating these tables other than with the load? If there are no updates that increase row size, pctfree=0 makes sense. If there are not a lot of updates that dramatically reduce row size and no deletes except prior to the load, pctused is moot since the blocks will never go back on the freelist anyway. If the relative volume of deletes or inserts is small, then pctused=0 might be preferable. That would reduce block shuffling on and off the freelist(s) and simply allocate new blocks for any inserts. The tradeoff is space and data density. The table would grow as inserts are performed and the density of data in the existing blocks would decrease as deletes are performed. Extent sizing may matter - to reduce or eliminate dynamic extent allocation as inserts are performed.

-Don Granaman
[OraSaurus - Honk if you remember UFI!]

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 02, 2001 6:40 AM

> Hello !
> After having defined all the tables, now I have to parametrize each table.
> I have some tables that every day must be deleted and reloaded through sql
> loader.
> I think to set PCTFREE = 0, but I don't know if I have to specify a
> particular value for PCTUSED.
> Anybody can give an advice about which value set PCTUSED ?
>
> Thanks in advance,
> Andrea

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: granaman_at_home.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).