|
Snapshot Level Database Table Space Application |
Logical Data Grouping dbase tablespace appl |
Monitor Switch Basic Basic Basic |
|
Resettable |
Yes |
|
|
Event Type Database Connection |
Logical Data Grouping db_event conn_event |
|
|
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.