Commit Statements Attempted


 
Snapshot Level
Database
Application
DCS Database
DCS Application


 
Logical Data Grouping
dbase
appl
dcs_dbase
dcs_appl


 
Monitor Switch
Basic
Basic
Basic
Basic


Resettable


Yes


 


Event Type
Database
Connection


Logical Data Grouping
db_event
conn_event


 


Element Name
Element Type


commit_sql_stmts
counter

 

Description:  The total number of SQL COMMIT statements that have been attempted.

Usage:  A small rate of change in this counter during the monitor period may indicate that applications are not doing frequent commits, which may lead to problems with logging and data concurrency.

You can also use this element to calculate the total number of units of work by calculating the sum of the following: 

 
   commit statements attempted
 + internal commits
 + rollback statements attempted
 + internal rollbacks
Note:The units of work calculated will only include those since the later of:
  • The connection to the database (for database-level information, this is the time of the first connection)
  • The last reset of the database monitor counters.

This calculation can be done at a database or application level.