Snapshot Information Level Database Table Space Application |
API Structure(s) sqlm_dbase sqlm_tablespace sqlm_appl |
Monitor Group Basic Basic Basic |
Resettable |
Yes |
|
Event Information Level Database Connection |
API Structure(s) sqlm_db_event sqlm_conn_event |
|
API Element Name Element Type |
select_sql_stmts counter |
Description: The number of SQL SELECT 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 SELECT statements to the total statements:
select 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 ]