Re: LMT with autoallocate

From: Mark Bole <makbo_at_ecis.com>
Date: Sun, 11 Nov 2001 16:23:36 GMT
Message-ID: <3BEEA607.E4CC5761@ecis.com>

I have seen several times the recommendation to only use uniform extents with LMT instead of "autoallocate", but no explanation as to why?

We have been using LMT with autoallocate for a long time (admittedly not a huge DB) with no problems...

Connor McDonald wrote:

> Thomas Kyte wrote:
> >
> [...]
> > >
> > >Could someone who has used LMT (locally managed tablespaces) with
> > >either autoallocate or uniform extents comment on their alleged
> > >performance benefits, administrative issues, etc?
> > >
> [...]
> >
> > locally managed tablespaces are (with the glaring exception of system) the ONLY
> > type of tablespace I use. I only use UNIFORM, never autoallocate.
> >

[...] Received on Sun Nov 11 2001 - 10:23:36 CST