SQL> conn scott/tigger
Connected.
SQL>
SQL>
SQL> select distinct sid from v$mystat;

SID
----------
28

SQL> create table t( a varchar(3), b varchar(2));

Table created.

SQL> insert into t values('aaa','bb');

1 row created.

SQL>

conn / as sysdba

SQL> select SQL_ID from v$session s,v$transaction t where s.TADDR=t.ADDR;

SQL_ID
-------------
g23fmpu17zwku

SQL> select SQL_TEXT from v$sqlarea where SQL_ID='g23fmpu17zwku';

SQL_TEXT
--------------------------------------------------------------------------------
insert into t values('aaa','bb')

ITPub博客

Check the transaction running in oracle