TOD – Rollin', Rollin', Rollback that data July 30, 2008
Posted by grumpydba in general, Tip 'o the day.Tags: rollback, v$transaction
add a comment
A long insert, update or delete has just finished, but you have to roll it back. Once you type “rollback” you sit and wait, and wait and wait. There is a query to see how much work is left, it won’t give you the amount of time left, but you can get an ideal of how many rows and blocks are left.
select used_urec, used_ublk from v$transaction;
It may take a little work to figure out which transaction is yours if there are several uncommitted transactions at the time, but if it is a big rollback it will be easy to see.
