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!!