Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: rollback segment

Re: rollback segment

From: Matthieu DEGLIN <mdeglin_at_partner.auchan.com>
Date: Wed, 20 Jun 2001 13:47:48 +0200
Message-ID: <9gq277$eqg$1@reader1.imaginet.fr>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US