Question : oracle transaction rollback not working
Answered by : vastemonde
SELECT CASE WHEN bitand(FLAG, power(2, 7)) > 0 THEN 'Rolling Back' ELSE 'Not Rolling Back' END AS "Rolling Back Status"
FROM V$TRANSACTION
WHERE ADDR IN (SELECT TADDR FROM V$SESSION WHERE USERNAME = 'USER_NAME');
Source : | Last Update : Sat, 18 Sep 21