|
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 |
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