How to monitor transaction Rollback Progress

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 …

How to monitor transaction Rollback Progress Read More »