Checking active transactions using v$transaction view

Checking active transactions

insert into f_regs1 values (1,'PAK');


select xidusn, xidsqn from v$transaction;

XIDUSN XIDSQN
5 95878

COMMIT

select xidusn, xidsqn from v$transaction;

no rows selected

delete from f_regs1

select xidusn, xidsqn from v$transaction;

XIDUSN XIDSQN
11 84932

rollback


select xidusn, xidsqn from v$transaction;

no rows selected