Snapshot Information Level Database Application |
API Structure(s) sqlm_dbase sqlm_appl |
Monitor Group Basic Basic |
Resettable |
Yes |
|
Event Information Level Database Connection |
API Structure(s) sqlm_db_event sqlm_conn_event |
|
API Element Name Element Type |
rollback_sql_stmts counter |
Description: The total number of SQL ROLLBACK statements that have been attempted.
Usage: A rollback can result from an application request, a deadlock, or an error situation. This element only counts the number of rollback statements issued from applications.
At the application level, this element can help you determine the level of database activity for the application and the amount of conflict with other applications. At the database level, it can help you determine the amount of activity in the database and the amount of conflict between applications on the database.
| Note: | You should try to minimize the number of rollbacks, since higher rollback activity results in lower throughput for the database. |
It may also be used 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
[ Top of Page | Table of Contents | Glossary | Index ]