Quote:
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:cool:
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.