Re: help: How big the rollback segment should be

Mike F wrote:
>
> We need to delete about 3m rows each day. Each row is about 32 bytes,
> does that mean we need to create a rollback segment of 92m bytes for
> that operation?
>
> Thanks for your help.
>
>
>
> --
> Sent by dbadba62 from hotmail within area com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new

Your logic is pretty much right (delete's need to rollback an entire row - it would be much less for inserts)... You could get a more accurate by deleting a sample and checking v$transaction and v$rollstat for the amount of activity.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."