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