Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to determine the number of transactions per minute
Hi,
You can count how many commits thare are per minute,hour,...
select v$sysstat.value from v$sysstat, v$statname where v$statname.name='user commits' and v$sysstat.statistic#=v$statname.statistic#;
Counting user rollbacks is also interesting sometimes.