Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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!! Received on Tue May 20 2003 - 08:14:57 CDT