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?
The table is big, about 250 Million rows in it.