Re: locally managed tablespace & dictionary managed tablespace

"Bert Bear" <bertbear_at_NOSPAMbertbear.net> wrote in message news:4nRP9.2529$da3.1526135006_at_newssvr11.news.prodigy.com...
> Andi,
>
> IMHO, LMT are the only way to go. This opinion is from 23 years of being
a
> operating system developer (e.g. file systems, IPC, GUI, schedulers,
> dispatchers, memory management, internal trace, abend processing
> backup/recovery applications, etc.) on three different operating systems
> (IBM VM, Cray UNICOS, and IBM OS/2). The design of LMT is much better
than
> DMT (and the implementation seems to be better).
>

Oh please. What exactly does 23 years' experience in memory management buy you in terms of this discussion?

What does "the design of LMT" mean? Tell us, please, about the block dumps you've performed to verify and ascertain the innards of said design. If design is really an issue, tell us what you'd have changed, or precisely why Oracle's design is so f***ing perfect.

Exactly *WHY* do you think the implementation of LMT (which had quite a few bugs in 8.1.5) is "better" than the implementation of DMT, which has been standard for well over 5 versions of Oracle, and has (practically) any bugs it ever possessed long since ironed-out?

Honesty. LMTs get the vote for all sorts of reasons, but design and implementation are the *very* least of them.

So what we're left with is 23 years of largely irrelevant experience and an "IMHO". Do you not think the original poster deserves better than that? Like reasoned argument, maybe?

Regards
HJR
> http://www.bmoshier.net/bertram
>
>
> "andi" <andi_at_a.com> wrote in message
> news:auodnb$7d5$1_at_mawar.singnet.com.sg...
> > Hi,
> > newbie question.
> > I've read some books which mentioned about advantages of locally-managed
> > tablespace over dictionary-managed tablespace.
> > My question is, are there advantages of dictionary-managed tablespace
over
> > locally-managed tablespace ?
> > or when should we use dictionary-managed tablespace instead of
> > locally-managed tablespace ?
> >
> > TIA,
> > Andi
> >
> >
> >
>
>
Received on Mon Dec 30 2002 - 00:56:39 CST