undo kill

How to monitor transaction Rollback Progress

August 21, 2021 by techgoeasy Leave a Comment

I had a situation where I had to killed the long-running session in my Oracle database. The session does not terminate immediately. It is marked for the 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 […]