If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

killed session from OS. How to check rollback progress

I killed an Oracle session from OS(Unix) using kill -9. Before the session was killed it was showing more than 400,000 blocks in used_blk in V$Transaction.
After the session was killed, I don't see anything in v$transaction (right after that). How can I know if the rollback completed or not?

I am not sure if I am right, but thought of bringing this to forums attention. I saw a lot of activities going on in the view: v$fast_start_transactions. I know this is related to undo segments.
When I stop seeing changes in this view, the query against the table started running normally.