It depends on how you killed the process.

If you did and alter system kill session you should be able to look at the used_ublk block in v$transaciton to get an estimate for the rollback being done.

If you killed to server process in the OS and pmon is recovering the transaction you can look at V$FAST_START_TRANSACTIONS view to get the estimate

One Response to “How can I check if there is anything rolling back?”

1. famegaurav says:

   October 15, 2010 at 1:35 pm

   To check for rollback:
   ##########################################################################

   select used_ublk from v$transaction where ADDR=;

   If there is a value there, this is the number of undo blocks used by the
   transaction. Wait one minute and again select “used_ublk” from
   “v$transaction” where ADDR=; .

   Note the value. If it is decreasing, a rollback is occuring and based on the
   difference between these values, you can “guesstimate” the time required to
   complete the rollback. For example, if the first query returns a value of
   80000 and the second one returns 70000, it took 1 minute to rollback 10000
   blocks. Based on this number, you can guestimate the time to complete the
   rollback. In this case, it would be 7 minutes.