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: Auto Extent Size

Re: Auto Extent Size

From: Mohamed Buhari <mbuhari_at_assigncorp.com>
Date: 25 Jan 2000 13:36:45 EST
Message-ID: <388DEC9F.525FEED4@assigncorp.com>


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

Original text of this message

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