Select SQL Statements Executed

 
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.