dummy_commit

>> SELECT SYS_CONTEXT('userenv','sid') sid, dbms_transaction.local_transaction_id tid FROM dual;

SID        TID
---------- ---------------
264

>> SELECT name,VALUE
  2  FROM v$sesstat s,v$statname n
  3  WHERE s.STATISTIC#=n.STATISTIC#
  4    AND n.name IN ('user commits','user rollbacks')
  5    AND s.sid=SYS_CONTEXT('userenv','sid');

NAME                                                                  VALUE
---------------------------------------------------------------- ----------
USER commits                                                              0
USER rollbacks                                                            0

>> SAVEPOINT a;

SAVEPOINT created.

>> SELECT SYS_CONTEXT('userenv','sid') sid, dbms_transaction.local_transaction_id tid FROM dual;

SID        TID
---------- ---------------
264        28.26.964404

>> SELECT name,VALUE
  2  FROM v$sesstat s,v$statname n
  3  WHERE s.STATISTIC#=n.STATISTIC#
  4    AND n.name IN ('user commits','user rollbacks')
  5    AND s.sid=SYS_CONTEXT('userenv','sid');

NAME                                                                  VALUE
---------------------------------------------------------------- ----------
USER commits                                                              0
USER rollbacks                                                            0

>> COMMIT;

COMMIT complete.

>> SELECT name,VALUE
  2  FROM v$sesstat s,v$statname n
  3  WHERE s.STATISTIC#=n.STATISTIC#
  4    AND n.name IN ('user commits','user rollbacks')
  5    AND s.sid=SYS_CONTEXT('userenv','sid');

NAME                                                                  VALUE
---------------------------------------------------------------- ----------
USER commits                                                              0
USER rollbacks                                                            0