You would also have to allow for all of the indexes associated with that table
when estimating the rollback size required.
Linda
In article <gbc-ya02408000R1707981954580001_at_news.slip.net>, gbc_at_slip.net
says...
>
>
> I've read all the info I can find regarding sizing rollback segments.
>The one item I can't find is this....
>
> How big (total size) should a rollback segment (or rather the TS holding
>the segment) be to accomodate an update of every column on every row of a
>particular table. Yeah, a bit vague. Assume the data (using VSIZE) is
>sized to be 100MB, and is all contained in the first extents sized at
>150MB. What size rollback segment/tablespace is necessary?
>
> Intuitively, I would say 100MB, or maybe 150MB. But I tried that and
>ended up needing much much more, in fact over 400% more.
>
>thanks - gene
>gbc_at_slip.net
Received on Mon Jul 20 1998 - 07:55:37 CDT
