Jul
28
2010
How can I check if there is anything rolling back?
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
