Database Rebuild
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database Rebuild

  1. #1
    Join Date
    Jun 2001
    Posts
    19

    Unhappy Database Rebuild

    Hello..

    I am looking to rebuild my 80 gig database with an 8k block in the next couple of weeks and doing a reorg at the same time. I am implementing locally managed tablespaces with a uniform extent size. I would like to use the advice I found in the article "How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation". My question is what extent sizes to use? The article recommends 3 sizes: 128k, 4m & 128m. If I have a table that is 9 gig in size it would literally use thousands of extents using an initial and next of 128m. What sizes would be the best to use? I have tables ranging from 260k to 9g. Thank you for your advice!!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    I'm not sure how you round, but I wouldn't group 72 in with "thousands".

    9*1024/128=72
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,967
    Given an 80gb database you probably want your extent sizes to be larger than 8k. 16k or 32k extent sizes wouldn't be unreasonable. If you choose to make them larger it would be because you know that your database reads data in large chunks.
    Last edited by gandolf989; 05-20-2003 at 09:33 AM.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by gandolf989
    If your 9gb tables were in tablespaces that had 512mb uniform extents then they would have around 180 extents each.
    Check your math on that one. 9/.5 = 18.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,967
    I did and realized you had a simpler way of showing the number of extents. Thanks for mentioning it.

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