Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: question about automatic undo management
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 ...Received on Thu Jan 23 2003 - 04:07:00 CST
>
>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.
>