Intial Extent Calculation

[badrinathn]

Hi,
How do I calculate the Intial extent,next extent values for
1) createing tablespaces
2) createing tables;

Can you please suggest

Badrinath

[sreddy]

There is tech paper on SAFE in the following thread. It really doesn't matter what your extent size is until it doesn't spread too many extents. You can create for small tables small extent size and for medium tables medium extent size and large tables give its own tablespace with relevant extent size.

[url]http://www.dbasupport.com/forums/showthread.php?threadid=5723[/url]

[Edited by sreddy on 02-21-2001 at 01:19 PM]

[kuckoo]

[QUOTE][i]Originally posted by badrinathn [/i]
[B]Hi,
How do I calculate the Intial extent,next extent values for
1) createing tablespaces
2) createing tables;

Can you please suggest

Badrinath [/B][/QUOTE]
suppose u have
intial 1m
next 2m
minextents 3
maxextents 121
pctincrease 20

Now, U have minextents=3 so u whenever u create table atleast 3 extents is reqd
Now for size,
FIrst extent will be 1m (inital 1m)
Next extent Will be 2m (Next 2m)
from third extent PCTINCREASE also used
SO for NExt (3'rd) extent will be
last extent*(1+pctincrease/100)
here it is 2*(1+20/100)=2(1.2)=2.4M
And it will take multiple of os block.

So ur extent will be 1m,2m,2.4m
Values of storage parameter at table level will look first
then at TS level Then at Default

kuckoo