Re: About Rollback Segments
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