Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segment size versus table size
It depends on how you are processing the table and how many indexes there are on the table. However, if your observation is correct, this does look a little extreme.
-- Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. Valérie HERAUD wrote in message <9pc2og$pdh$1_at_d03.completel.fr>...Received on Tue Oct 02 2001 - 13:41:47 CDT
>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
>
>
>
![]() |
![]() |