Re: question about automatic undo management

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 23 Jan 2003 10:07:00 -0000
Message-ID: <b0oesm$892$2$8300dec7@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 - 04:07:00 CST