Re: About Rollback Segments

From: Alan D. Mills <alanm_at_uk.europe.mcd.mot.com>
Date: 1997/12/08
Message-ID: <01bd03f9$342fa680$73d0658c_at_ukmhdam>#1/1


If you're clearing the whole table use

TRUNCATE TABLE mytab;

instead of

DELETE FROM mytab;

That'll avoid the rollback segments and be tons faster.

Hope this helps.

Extel Inc. <extel_at_shore.net> wrote in article <65q1ab$7mv_at_shell2.shore.net>...
> Philip Fielder <phil.fielder_at_mci.com> writes:
>
>
>
> >Jorge A. San Martn wrote:
 

> >> Hi,
> >> I have a lot of doubts about rollback segments (RS), I work with
[Quoted] > >> 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 [Quoted]
> >> 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 ?
> >>
>
>
> It may be obvious, and may already have been answered, but why is it
 necessary
> to do a million row delete inside a single transaction?!
>
>
Received on Mon Dec 08 1997 - 00:00:00 CET

Original text of this message