Opinions about no extents for a segment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Opinions about no extents for a segment

  1. #1
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360

    Talking

    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
    Posts
    301
    Hi,

    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.

    Vijay.
    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