Dynamic SQL Statements Attempted



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



dynamic_sql_stmts
counter

 

Description:  The number of dynamic SQL statements that were attempted.

Usage:  You can use this element to calculate the total number of successful SQL statements at the database or application level:

 
      Dynamic SQL Statements Attempted
    + Static SQL Statements Attempted
    - Failed Statement Operations
    = throughput during monitoring period