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>...
>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 - 13:41:47 CDT
