Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: rollback segment
I've already encountered this problem!
In fact, droping and recreating your RBS is a way to solve your problem.
Another solution is to create a bigger RBS and force your batch to use it
with:
SET TRANSACTION USE ROLLBACK SEGMENT RBS_BIGGER
Gildas COTOMALE a écrit dans le message <9gpkkn$hhh$1_at_klin.lan.klee.fr>...
>Some times (not often) when my batch file perform a too long operation,
>Oracle hang du to a full rollback segment problem. I use 16 rollback
>segments of 400 Mo.
>Is there a solution ? Will it help to drop and recreate rollback segments
>(to be sure they are completely purged) ? Any hint ? Thanks.
>
>
>
>
>
Received on Wed Jun 20 2001 - 06:47:48 CDT