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 |
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.
[ Top of Page | Table of Contents | Glossary | Index ]