|
-
You don't want the extents to be > 1000 for performance reasons (either LMT or DMT). Pick a reasonable number of extents to start out with, say one per data file.
If you initially have a table that is 4M that you know will eventually be 20M, start out with INITIAL 1M NEXT 1M PCTINCREASE 0. You shouldn't grow beyond 20 extents with your data, but if you do, it's no big deal.
See http://otn.oracle.com/docs/products/...block.htm#5476 for details.
Jeff Hunter
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
|