I wonder if it can be affected by how busy smon is
on other tasks when the call for a new undo segment
occurs.
--
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 ...
>Oh well, that wasn't my experience last night. 10 undo segments
created at
>startup, in an 8GB undo tablespace. 10 transactions each allocated to
a
>separate segment, The 11th transaction caused a new segment to be
created.
>The twelfth was shared. The 13th created a new segment; the 14th was
shared.
>
>I didn't pursue it much further, but now perhaps I will.
>
>Regards
>HJR
>
Received on Thu Jan 23 2003 - 13:51:05 CST
