Re: question about automatic undo management

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:b0jcjl$igp$1$830fa78d_at_news.demon.co.uk...
>
> Since I include a section in my seminar on
> why it is a smart move to minimise total
> undo space if possible, I'd rather not have
> my name connected with any generic comments
> about being a moron if you don't throw diskspace
> at the undo tablespace.
>

First off, apologies if the 'association' caused you offence. The sentence in question was intended to be a jocular way of saying you *don't* need to be particularly bright to work the thing out. I think you'd have to stretch things to breaking point to read it as any kind of suggestion that J. Lewis himself thinks peoples are morons unless they do x, y or z.

There was a smiley face at the end of the entire thing, too.

Next time, I'll dig out the "Irony" neon sign.

> 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?

Regards
HJR
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Coming soon a new one-day tutorial:
> Cost Based Optimisation
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____England______January 21/23
> ____USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
> Howard J. Rogers wrote in message ...
>
> >I don't know. I'm not sure what you're suggesting here. All I know is
> that
> >anyone who skimps on undo tablespace is an utter moron. There's no
> excuses:
> >it's purely a question of disk space, and nothing terribly quantum,
> >relativistic, or requiring the IQ of Jonathan Lewis. And disk space
> is
> >cheap. And if it isn't, then you were a moron to sign up with that
> >particular vendor.
> >
> >;-)
>
>
>
Received on Tue Jan 21 2003 - 12:34:03 CST