undo kill

How to monitor transaction Rollback Progress

September 28, 2013 by techgoeasy Leave a Comment

I had a situation where I had to killed the long running session in my Oracle database.Session does not terminate immediately. It is marked for kill and the rollback is done in the background. SQL> ALTER SYSTEM KILL SESSION ’12,2233′; ALTER SYSTEM KILL SESSION ’12,2233′ * ERROR at line 1: ORA-00031: session marked for kill […]