Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: question about automatic undo management

Re: question about automatic undo management

From: Joel Garry <joel-garry_at_home.com>
Date: 21 Jan 2003 16:49:45 -0800
Message-ID: <91884734.0301211649.2d029eda@posting.google.com>


"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<IegX9.29683$jM5.76837_at_newsfeeds.bigpond.com>...
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:b0jcjl$igp$1$830fa78d_at_news.demon.co.uk...
> > Diskspace may be cheap, but I/Os are not, and
> > any strategy that results in redundant I/O is inherently
> > suspect. Allowing undo segments to become
> > unnecessarily large is one way of generating
> > redundant I/O.
> >
>
> But since SMON shrinks anything that it considers too large every 12 hours
> or so, this isn't going to be an issue, is it?

Sounds like the real world is bound to undo all gains from moving to LMT's by simply requiring too much undo for useless flashbacks.

jg

--
@home is bogus.
Moore's law ensconsed in a Klein Bottle and wrapped in a Moebius
strip.
Received on Tue Jan 21 2003 - 18:49:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US