Snapshot Level Database Application |
Logical Data Grouping dbase appl |
Monitor Switch Basic Basic |
Resettable |
Yes |
|
Event Type Database Connection |
Logical Data Grouping db_event conn_event |
|
Element Name Element Type |
uid_sql_stmts counter |
Description: The number of SQL UPDATE, INSERT, and DELETE statements that were executed.
Usage: You can use this element to determine the level of database activity at the application or database level.
You can also use the following formula to determine the ratio of UPDATE, INSERT and DELETE statements to the total number of statements:
update/insert/delete SQL statements executed / (static SQL statements attempted + dynamic SQL statements attempted )
This information can be useful for analyzing application activity and throughput.