Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

killing a rollback transaction...

ji liJul 16 2012 — edited Jul 16 2012
I've got a quick question:

I'm using 11GR2 on Linux RHel 5.

Question is that if there is a very large rollback operation going on that is lasting too long for comfort and our management says to kill the rollback transaction because it is holding a lock on the table, what would be the result?

So far, we've killed the transaction at the OS level, and the table lock is freed. How can this be since the transaction still has to roll back or we would have inconsistent data?

Is this something smon restores in the background process using UNDO space to hold any new transactions to the table while it is being rolled back?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2012
Added on Jul 16 2012
6 comments
2,578 views