Re: LMT and DMT

From: tingl <one4all_at_all4one.not>
Date: Wed, 05 Feb 2003 01:33:14 GMT
Message-ID: <uRZ%9.9$lg2.3942@newsread2.prod.itd.earthlink.net>

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:6RN%9.40328$jM5.102296_at_newsfeeds.bigpond.com...
> "tingl" <one4all_at_all4one.not> wrote in message
> news:tUE%9.6058$6P2.678346_at_newsread1.prod.itd.earthlink.net...
> > "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> > news:UHX_9.38406$jM5.97340_at_newsfeeds.bigpond.com...
> > > "tingl" <one4all_at_all4one.not> wrote in message
> > > news:MZU_9.2302$ek4.226461_at_newsread2.prod.itd.earthlink.net...
> > > > I would say a properly sized LMT is better than a poorly managed
DMT,
> > and
> > > > vice versa.
> > > >
> > >
> > > Hi Tingl,
> > >
> > > and I would say that the above is too simplistic a comment.
> > >
> > > There are advantages to LMT that make it easier to have a "properly
> > > configured LMT" and harder for the same to be said about DMT.
> > >
> > > I still think LMT is better ...
> > >
> > > Cheers
> > >
> > > Richard
> > >
> > >
> > >
> >
> > Hi Richard,
> >
> > I am not sure what you meant by too simplistic. My intention was to make
> it
> > less simplistic
> > than just "LMT is better.". Anyway there is a tradeoff between ease of
> > maintenance and
> > flexibility. LMT and DMT each has pros and cons. Neither is better than
> the
> > other in all
> > situations.
> >

>

> Hi Tingl,

>

> What can a DMT do that can't be performed or managed easier with a LMT ?

>

> This of course is all going to be a rather moot point as with 9.2, with a
> System LMT, DMT are not even possible and with 10i they'll probably be
gone
> for good.

>

> Cheers

>

> Richard

>
>
>

Hey Richard,

DMT gives you more options when it comes to extent sizes in a single tablespace.

What Oracle wants to do in the future is really besides the point. I am not even sure
if we will use Oracle if it comes to 10i. In the mean time we will continue to use DMT
until we have to make a choice between uniform LMT - the one-size-fit-all approach
or system LMT - the brain dead approach. :)

Tingl Received on Tue Feb 04 2003 - 19:33:14 CST