Re: About Rollback Segments

From: ivcais3 <ivcais3_at_mail.orc.ru>
Date: 1997/11/28
Message-ID: <01bcfc4b$fe21b560$070658c2_at_default>#1/1

Jorge A. San MartÌn <jsanmart_at_tortuga.its.cl> wrote:

> 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 ?
>
It is possible to think up some ways to solve this problem. For example: 1. That transactions were shorter, till 100 records, run with PL/SQL code:

    BEGIN

       LOOP
          Delete from TABLE _ NAME
          Where <condition>
          And ROWNUM < = 100;
         EXIT WHEN SQL%ROWCOUNT = 0;
         Commit;
      END LOOP;

   END;
2. Use PARTITION VIEW,

    then it will be possible replace DELETE to DROP or TRUNCATE.

---

Victor Abramov, ivcais3_at_mail.sitek.ru, Moscow Received on Fri Nov 28 1997 - 00:00:00 CET