Factors Affecting Rollback Speed
Hey Tom, 1. I would like to know the factors influencing the rollback speed of a transaction. And why does it generally take more than the time it took for the actual transaction. Could you show some light on this? 2. I read one of your answers where you have said "A rollback is a logical operation, if you just did 1,000,000 row inserts and roll them back - we now have 1,000,000 deletes to perform (including the index maintenance and everything) rollback insert = do a logical delete rollback delete = do a logical insert rollback update = do a logical update to put it back the way it was" How does the objects lock work here is it the same mechanism how the actual DML was done, or it will be different?
Factors Affecting Rollback Speed