Initial Extent size
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
why bother, just use locally managed tablespaces with system generated extents then you never need to worry about it again
I'm in agreement with Davey - this is a question that was relevant perhaps four or five years ago.
Originally Posted by sumit
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.
Click Here to Expand Forum to Full Width