The statement operation currently being processed
or most
recently processed (if none currently running).
Table 1. Snapshot
Monitoring InformationSnapshot Level |
Logical Data Grouping |
Monitor
Switch |
Application |
stmt |
Statement |
DCS Statement |
dcs_stmt |
Statement |
Table 2. Event Monitoring
InformationEvent Type |
Logical Data Grouping |
Monitor Switch |
Locking |
- |
- |
Deadlocks with Details1 |
event_detailed_dlconn |
- |
Statements |
event_stmt |
- |
- 1
- This option has been deprecated. Its
use is no longer recommended and might be removed in a future release.
Use the CREATE EVENT MONITOR FOR LOCKING statement to monitor lock-related
events, such as lock timeouts, lock waits, and deadlocks.
Usage
You can use this element
to determine
the operation that is executing or recently finished.
It can
be one of the following.
For SQL operations:
- SELECT
- PREPARE
- EXECUTE
- EXECUTE IMMEDIATE
- OPEN
- FETCH
- CLOSE
- DESCRIBE
- STATIC COMMIT
- STATIC ROLLBACK
- FREE LOCATOR
- PREP_COMMIT
- CALL
- PREP_OPEN
- PREP_EXEC
- COMPILE
- DROP
PACKAGE
For non-SQL operations:
- RUN STATISTICS
- REORG
- REBIND
- REDISTRIBUTE
- GET TABLE AUTHORIZATION
- GET ADMINISTRATIVE AUTHORIZATION
Note: API users
should refer to the sqlmon.h header
file containing definitions of database system monitor constants.