DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2000
    Birmingham, UK


    I'm looking for opinions on how many extents a segment has before performance starts to degrade. I want to move our dict managed tablespaces to locally managed and I'm thinking of choosing a uniform extent size that keeps the largest segment in the tablespace below 1000 extents. Any opinions?

  2. #2
    Join Date
    Mar 2002

    Actually the performance does not depend upon the total no. of extents. It depends
    upon whether the segment has fragmented or not. It also depends upon the
    distribution of the data.

    Say No To Plastics

  3. #3
    Yes, but more extents increase the risk/measure of fragmentation...
    It is good to make an equilibrium between space-wastage, finesse of allocation and performance/risk of performance decrease. And this could be done when you have an idea of what amount of data will you have in a segment and how dynamic your data will be.
    So, absolute numbers will tell you nothing. This is a relative issue.
    ovidius over!

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

By using this site, you agree to the Privacy Policy