-
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
-
Use locally managed tablespaces (LMT) and don't worry about extent sizes.
Jeff Hunter
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|