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

Thread: initial extent

  1. #1
    Join Date
    Dec 2001
    Posts
    320

    Question

    hi guys,
    when exactly do we need to increase the initial extent?
    what difference does it make if the initial extent is increased or no?
    another question, if i increase the initial extent and i have set the pctincrease to a number greater than zero, does that mean that the next extents will grow also? ( i mean the extents already created), well i don't think so but i need to know for sure.

    Thanks in advance

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Use locally managed tablespaces (LMT) and don't worry about extent sizes.
    Jeff Hunter

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    You can't increase the initial extent. Once set, that's it. Percent increase adds that much more to the next extent after the first next extent. With 50% as the default value, and you start with the first next at 40, the "next" one will be 40 plus 50% of 40 for a total of 60. Next one is 90, then 135, and so on. What a mess. As marist89 said, use LMT.

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