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
