Originally posted by phamou
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
How do you know this? Do you mean that a delete is removing 300mg of data and if so how are you determining this. How do you know this delete is using 9gb worth of rollback.

Are you using automatic undo?