Re: Looking for a good way to convert from dictionnary manged TBS to Locally managed ones

"Howard J. Rogers" <hjr_at_dizwell.com> a écrit dans le message de news:405a78c3$0$8355$afc38c87_at_news.optusnet.com.au...
>
> "Daniel Roy" <danielroy10junk_at_hotmail.com> wrote in message
> news:3722db.0403181919.3162bf41_at_posting.google.com...
> > > It has been argued and demonstrated here that UNIFORM is of little use
> > > and AUTOALLOCATE is the way to go, as this will make sure all extents
> > > are properly sized.
> > >
> > Can I ask where this has been "argued and demonstrated"? I've been
> > using uniform, and I'm quite happy with the result. I also group the
> > objects in tablespaces depending on their expected size (extents 8K,
> > 16K, 32K, ...).
> >
> > Daniel
>
> It's been discussed here quite recently, with Richard Foote posting an
> interesting test demonstrating that autoallocate is extremely difficult to
> fragment, and is extremely smart about the way it allocates space to
> objects. I'm sure you could hunt for it on Google. It would be within the
> last two months.
>

Difficult to fragment because of "fixed multiples" extent sizes ? I mean, even if they are not the same, they (almost) all can be reused ? Received on Fri Mar 19 2004 - 09:37:31 CST