| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problem in setting PCTFREE and PCTUSED
Andrea,
If it were me and I had tables that were reloaded every day, I would set the following:
PCTFREE=5 : Since you are not doing deletes & inserts, keep this small PCTUSED=95 : Since you are not doing updates, pack the data right in tight. PCTINCREASE=0 : I ALWAYS set this to 0.
and, make sure that the INITIAL extent size was large enough to hold all of the data.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, October 02, 2001 7:40 AM
To: Multiple recipients of list ORACLE-L
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: Quaglio Andrea
INET: Andrea.Quaglio_at_semagroup.it
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).
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). Received on Tue Oct 02 2001 - 08:13:19 CDT
 |
 |