Rollback Segment Sizing

Is there an algorithm to size rollback segment requirements for a program? e.g. If I have a program that updates 1 mil. rows in a table where rowsize = 100 , but the size of columns being updated is only 50, how can I calculate rollback requirements. Are there any general purpose scripts to figure rollback segment size for a database, depending no. of concurrent users and transaction sizes?

Also, does the kernel copy the entire datablock being modified in the rollback segment, or only the row being modified or something else?

Thanks in advance.

Sanat Received on Sat Aug 24 1996 - 00:00:00 CEST