Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Auto Extent Size
The default values are :
initial extent = 5 time your oracle block size
next extent = 5 times your oracle block size
pctincrease = 50
minextents = 2
maxextents = 121
It is not recomended to use oracles default rule. So your thumb rule is based on your own experience.Since your operation is insert intensive, I would suggest the following. Assume your tablesapce is 1GB
CREATE TABLE ..... STORAGE ( INITIAL 500K next 500 K minextents 10 maxextents UNLIMITED PCTINCREASE 1 PCTUSED 60 PCTFREE 15 FREELISTS 2 ); If U have a muti CPU system, make FREELISTS to the number of CPU's to avoid freelist contention. Make pctincrease between 1 and 5 to enable automatic coalesing by smon.
Mohamed Buhari
oracle dba
mshabrawi_at_excite.com wrote:
> Hello,
> How can I know the default size that Oracle Server 8i gives to extent
> Objects(tables, etc...) and how to change it ?
> Also How to estimate the best Initial, and auto extent sizes that
> should be assigned to certain Table taking inzo consideration that I
> have approximate figure for the number of records that would be
> inserted in this table per day (about 30,000 record)
>
> -We are migrating our Database application from microsoft server to
> Oralce and the voulmetric sizing of Database is of great importance due
> to the oarge number of records that will be entered daily.
>
> Thanks in advance,
> Mohamed EL-Shabrawi
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 25 2000 - 12:36:45 CST
![]() |
![]() |