Re: Shrewd way to avoid 'snapshot too old'?

Only if there is a reason why the rollback segments cannot extend (max extents
reached, tablespace too small). The
presence of the uncommitted transaction
simply ensures that the rollbacks extend instead of wrapping.

Naturally you would have OPTIMAL set
so that after this special job had finished the rollbacks would eventually shrink.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Greg Stark wrote in message
<87d7lmffqi.fsf_at_HSE-Montreal-ppp138319.sympatico.ca>...


>

>

>Don't the transactions just get "Can't extend rollback segment" and fail

>themselves?

>

>--

>greg