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

Home -> Community -> Usenet -> c.d.o.misc -> Re: About Rollback Segments

Re: About Rollback Segments

From: SUVAS LAKSHMIKUTTYAMMA <lsuvas_at_worldnet.att.net>
Date: 1997/12/09
Message-ID: <66ikr9$q90@bgtnsc02.worldnet.att.net>#1/1

Looks like you have gone out of extents in your Rollback segment. Create a big enough rollback segment and set the transaction to it by
"SET TRANSACTION USE ROLLBACK SEGMENT <BIG_ROLLBACK_NAME>" No need for disable.In fact you have to enable your big rollback by the above command.
Hope this helps

Jorge A. San Martín <jsanmart_at_tortuga.its.cl> wrote in article <347F484D.8CD2DD84_at_tortuga.its.cl>...
> Hi,
> I have a lot of doubts about rollback segments (RS), I work with
> Oracle Server 7.3.2.3, we have a table with a lot of records; 1,000,000
> daily aprox, which must be deleted, but the rollback segments excedes
> the MAXEXTENTS parameter. I have read the manual about RS, but I don't
> know what values are the bests for a RS for this task. Is there a way
> to disable the RS ?
>
> Thanks,
> Saludos
> Jorge San Martín.
> jsanmart_at_its.cl
> ITS S.A.
>
>
Received on Tue Dec 09 1997 - 00:00:00 CST

Original text of this message

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