Hi,

I need to know approximatly how much rollback are used in a large delete transaction.
the table implied in the delete has several "on delete cascade" constraints under it, witch causes a 300MB delete to use about 9Gigs of Rollback space.

do you know a way of tracking the rollback that could be used in a delete transaction or can you give me a way of knowing the actual size of all the records implied in the delete statement (with the "on delete cascade" sub-tables data too).

thanks & have a good day!

Patrick