Re: Automatic Undo Managment on 9i

Gawd. You don't want to touch dictionary managed tablespace anymore.

Probably in 10i, DMT will be obsolete.

Already in 9iR2, if you have a SYSTEM tablespace that's LMT, then you can't actually create DMTs anywhere else.

No, LMTs are brilliant, and are thoroughly recommended.

(Incidentally, I would avoid autoextend if at all possible, only on the grounds that the datafile involved will autoextend when you least want it to: right in the middle of someone's transaction. But certainly, automatic undo+autoextend is a bit of a no-brainer exercise, management-wise).

Regards
HJR "Timmy Sin" <tswsin_at_yahoo.com> wrote in message news:ats1in$h0u$1_at_news.hk.linkage.net...
> Thanks Howard and Daniel.
>
> So, I can just create a single undo tablespace, enable it to be AUTOEXTEND
> and no more administration and sizing is required.
>
> How about the feature "local management tablespace" already available in
8i?
> Are you using them or the dictionary management tablespace?
>
> Thanks,
> Timmy
>
> "Timmy Sin" <tswsin_at_yahoo.com> ¼¶¼g©ó¶l¥ó·s»D
> :atpihg$nkn$1_at_news.hk.linkage.net...
> > Hi All,
> >
> > I am upgrading from 7.X to 9i Rel. 2.
> > Should I use the new feature of automatic undo management or keep on
using
> > rollback segments?
> > Is the new feature reliable?
> >
> > Thanks in advanced.
> >
> > Regards,
> > Timmy Sin
> >
> >
>
>
Received on Thu Dec 19 2002 - 03:05:07 CST