Re: Database Rebuild

From: I.A. Saez <i.a.saez.scheihingGEENSPAM_at_tue.nl>
Date: Tue, 20 May 2003 17:06:48 +0200
Message-ID: <3ECA4488.57939E2E@tue.nl>

Ocp8,

You can beter define your locally managed tablespace with automatic allocation. Tables will start
with 64K initial and extents of 64K and will continue to grow and after x extents it will
jump to 1 M extents and after x more extents it will jump to 8M. See http://www.dbazine.com/jlewis8.html for a better explanation. So define your locally managed tablespace
with automatic allocation and stop worrying.

kind regards,

Ivan

ocp8 wrote:

> 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 - 10:06:48 CDT