Nothing is guaranteed without examining the source code ;)
However, my tests indicated most strongly that the normal
round-robin would take place - with the usual proviso that the
rollback segments with fewest current transactions are given
precedence.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Yong Huang wrote in message <8rdjim$j5h$1_at_news.sinet.slb.com>...
>Jonathan,
>
>Is it guaranteed that a new transaction (after the old transaction is
>committed) will use a different rollback segment from the one the old
>transaction used?
>
>Yong Huang
>yhuang_at_indigopool.com
>
>Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message
>news:970598165.15505.1.nnrp-10.9e984b29_at_news.demon.co.uk...
>> Use COMMIT 10000 to make the 'transaction' commit
>> after cleaning up every 10,000 rows. This will keep
>> Oracle switching rollback segments very 10,000 rows.
>
>
>
Received on Wed Oct 04 2000 - 01:05:56 CDT
