The following is found in the
Database Monitor and provides you with an overview of SQL statement components.Table: Commands
Command Type |
Command Function |
SQL command |
Number of statements sent to the database for processing. This is a direct indicator of database activity. |
Rollbacks |
Indicate unsuccessful database actions, usually as a result of a terminated application. |
Commits |
Indicate successful database actions. |
Prepares |
Number of dynamic SQL statements |
Executes |
Number of dynamic SQL statements executed |
The ratio of rollbacks to commits can indicate logical inconsistencies in one or more SQL statements.
See also:
Performance Database