Check active transaction in Oracle
V$TRANSACTION view help in search for the transaction which is actually executing or waiting for the resources in the Oracle Database system. When you are working with DML or Begin-End statements, you can confirm the details of a transaction by querying from the V$TRANSACTION view.
For Example
In Example, we are inserted data into a table EMP then hold for issue a COMMIT or ROLLBACK Statement,In mean time you can view active transaction information for the currently connected session as follows:
-- Insert the row into the table.
SQL> insert into emp values(1, 'John', 'Smith');
-- Check the active transaction from view.
SQL> select xidusn, xidsqn from v$transaction;
XIDUSN XIDSQN ---------- ---------- 9 369
-- Commit will make the changes permanent and close the transaction.
SQL> commit;
-- After commit means tranction is finished.
SQL> select xidusn, xidsqn from v$transaction;
no rows selected