-
Initial Extent size
Hi,
I need your thoughts on configuring large initial extent size of 256K across all tables in a large schema.
Large extent good or bad?
Thanks and Regards
sumit
-
why bother, just use locally managed tablespaces with system generated extents then you never need to worry about it again
-
Originally Posted by sumit
I need your thoughts on configuring large initial extent size of 256K across all tables in a large schema.
Large extent good or bad?
I'm in agreement with Davey - this is a question that was relevant perhaps four or five years ago.
Answerig your question, it all depends on table size and data volatility. What would be good for a particular table would be bad for other.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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
|