Re: Anyone used SAFE to eliminate fragmentation ?

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Fri, 23 Feb 2001 14:59:11 -0000
Message-ID: <982940663.12778.0.nnrp-02.c2de6f3d@news.demon.co.uk>

Nuno Souto wrote in message <3a9649f5.10960219_at_news-server>...
>On Fri, 23 Feb 2001 10:15:02 -0000, "Neil Cudd"
><neil_at_cudd.demon.co.uk> wrote:
>
>>I'm about to reorg one of my databases and would like to implement the
>>Simple Algorithm for Fragmentation Elimination as discussed in the Oracle
>>white paper (#771). Has anybody else had experience of this method and any
>>hints/tips they would like to pass on ?
>>
>
>Yes. Love it.
>Tip? Try it on a few tablespaces first to make sure you got the hang
>of it.
>Don't use the MINIUM EXTENT SIZE of 8i just yet. I've seen problems
>with TRUNCATE table in some ports of 8.1.6. That's if you want to use
>that parameter, you don't need it really for SAFE.
>
>Cheers
>Nuno Souto

Thanks for the tip. I was going to do a phased move over the next 5 -6 weeks so I should get used to it.

Can I ask how large the database is that you implemented on ?

Thanks,

Neil. Received on Fri Feb 23 2001 - 08:59:11 CST