Re: question about automatic undo management

In article <IegX9.29683$jM5.76837_at_newsfeeds.bigpond.com>, "Howard says...
>
>
>"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.

He, he, there have been any number of times that Jonathan has called me a "silly chap" or something similar, and I'm sure that's the English version of the Aussie "moron". Only problem is he's never given me the opportunity to return the favour!!! :)

Pete
>
>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.
>> >
>> >;-)
>>
>>
>>
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Tue Jan 21 2003 - 19:30:50 CST