-
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?
The table is big, about 250 Million rows in it.
-
if it isn't in v$transaction then the rollback is complete
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|