Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: question about automatic undo management
"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
![]() |
![]() |