Re: question about automatic undo management

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.

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.

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

>

>;-)