How to find "user commits" during a user session

You can find number of "user commits" during a particular user session. Just get the SID of the user for which you want to track the number of commits.


set lines 120
set pages 1000
col name format a25
select a.*,b.* from sys.v_$sesstat a, sys.v_$statname b
where a.STATISTIC#=b.STATISTIC#
and b.name like '%user%'
and a.sid=&input_sid
/