Statement Type

 
Snapshot Level
Application

 
Logical Data Grouping
appl
stmt

 
Monitor Switch
Statement
Statement

Resettable

No

Event Type
Statement

Logical Data Grouping
stmt_event

Element Name
Element Type

stmt_type
information

Description:  The type of statement processed.

Usage:  You can use this element to determine the type of statement that is executing. It can be one of the following:

• A static SQL statement
• A dynamic SQL statement
• An operation other than an SQL statement; for example, a bind or pre-compile operation.

For the snapshot monitor, this element describes the statement that is currently being processed or was most recently processed.

Note:

API users should refer to the sqlmon.h header file containing definitions of database system monitor constants.