Posts tagged: V$FAST_START_TRANSACTIONS

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

Alibi3col theme by Themocracy