Re: question about automatic undo management

I think you're being a bit harsh.

Where would you *like* people to do data modelling?!

Of course there are costs, but the benefits for the right app. are huge.

Regards
HJR "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:b0oesm$892$2$8300dec7_at_news.demon.co.uk...
>
> Oh dear,
>
> Workspace Management is another disaster
> waiting to happen to someone who doesn't
> realise that changing your mind is probably
> the most expensive operation you can do
> in Oracle.
>
> --
> 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've done modelling with global temporary tables (8i and 9i), and of
> course
> >the prize whatiffing strategy must go to Workspace Management (9i
> only).
> >Either way, undo is generated, it's true, but I don't see either
> strategy
> >*necessarily* straining undo I/O. And if large amount of undo are
> generated,
> >and that starts becoming an I/O problem, then configure more undo
> tablespace
> >datafiles and stripe them across more hard disks.
> >
>
>
>
Received on Thu Jan 23 2003 - 05:12:31 CST