Predicting Oracle Transaction Rollback Time

While waiting for a large transaction to roll back, I’ve cooked this spreadsheet which can, to some extent (not precise, just estimated – use at your own risk) predict how long it will take for the rollback to complete.

ScreenshotThe spreadsheet takes as input the amount of undo records used by the transaction at two points in time (USED_UREC field from V$TRANSACTION) and the time you got both values, it then calculates the speed at which the rollback is happening, and makes a prediction.

Click to download the Rollback Prediction Spreadsheet, and please let me know if you like it. Thanks!

Advertisements
This entry was posted in Oracle, Performance, Troubleshoot and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s