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

Home -> Community -> Usenet -> c.d.o.server -> too much rollback segment usage

too much rollback segment usage

From: charlie cs <cs3526_at_ureach.com>
Date: Tue, 01 Oct 2002 22:10:59 GMT
Message-ID: <T3pm9.3389$817.80@nwrddc04.gnilink.net>


too much rollback segment usage

I was doing
SQL> desc test
Name Null? Type

----------------------------------------- -------- -------------------------
---
DASET_ID NOT NULL NUMBER(10)
SECT_ID NOT NULL NUMBER(10)

begin
for i in 1 .. 10000000 loop
insert into test values (i,1);
end loop;
commit;
end;
/
PL/SQL procedure successfully completed.

After it finish, the highwater mark of table is only 150M, but during the
inserts, rollback segments grow up to 680M, why do we need such a big
rollback segments for such a small table?   According to some OCP book,
insert only store new rowid into the rollback segments.

Thanks for your help.

by the way, there is no indexes on the table
Received on Tue Oct 01 2002 - 17:10:59 CDT

Original text of this message

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