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

Thread: Initial Extent size

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why bother, just use locally managed tablespaces with system generated extents then you never need to worry about it again

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by sumit View Post
    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
  •  



Click Here to Expand Forum to Full Width