Re: Rollback segment size versus table size

From: Stephan Bressler <stephan.bressler_at_pdb.sbs.de>
Date: Tue, 2 Oct 2001 12:08:35 +0200
Message-ID: <9pc3n3$7n1$1@news.mch.sbs.de>

Hi,

I can think of 2 possible reasons:
1. another transaction is using the same rbs and needs very much space

==> check v$transaction to determine the rbs usage of YOUR transaction 2. you have triggers defined on your table causing a lot of modifications in the db, which

in turn creates a lot of rollback data.

Hope that helps
Stephan

"Valérie HERAUD" <valerie.heraud_at_acanthis.fr> schrieb im Newsbeitrag news:9pc2og$pdh$1_at_d03.completel.fr...
> Hello,
>
> I wonder if the behavior I have noticed is normal or not.
> To process a table with 1000 records with a row size of 737 each, the
> rollback segment size increases until 106 Mo.
>
> Is it not too large for a little table ? What can be the cause of this
large
> size ?
>
> Thanks in advance for help.
>
> Valérie
>
>
>
Received on Tue Oct 02 2001 - 05:08:35 CDT