Oracle user_transactions component monitor - per-second or delta?

rharland2012

Having a hard time finding a good answer on this one - and my Oracle admin is the person asking me, so....

In the component monitor for Oracle, when we get a figure for the 'User transactions' query, is that per-second, or from start of service, or something else?

Thanks for any info.

aLTeReGo

From: http://docs.oracle.com/cd/B16240_01/doc/doc.102/e16282/oracle_database_help/oracle_database_instance_throughput_commits_pt.html

This metric represents the number of user commits performed, per transaction during the sample period. When a user commits a transaction, the redo generated that reflects the changes made to database blocks must be written to disk. Commits often represent the closest thing to a user transaction rate.

The value of this statistic will be zero if there have not been any write or update transactions committed or rolled back during the last sample period. If the bulk of the activity to the database is read only, the corresponding "per second" metric of the same name will be a better indicator of current performance.

This test checks the number of user commits per transaction. If the value is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences" parameter, then a warning or critical alert is generated.