Intial Extent Calculation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Intial Extent Calculation

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,
    How do I calculate the Intial extent,next extent values for
    1) createing tablespaces
    2) createing tables;

    Can you please suggest

    Badrinath

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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]
    Reddy,Sam

  3. #3
    Join Date
    Feb 2001
    Location
    Baltimore,MD USA
    Posts
    27
    [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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width