Statements / In Flight Statements
Purpose
In-flight statements view shows a list of SQL statements that are currently running. This is useful for identifying statemnts that are costly or long running.
Drill down is provided to see the full SQL text or run explain on a statement.
Screenshot
Metric shown
Application handle
A system-wide unique ID for the application.
Source: MON_GET_CONNECTION(NULL, #MEMBER#, 1).APPLICATION_HANDLE
Stmt num
Statement number within a package for a static SQL statement.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).STMTNO
Cpu time
The total amount of CPU time used while within the database system.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).SUM(TOTAL_CPU_TIME)
Application name
The name of the application running at the client.
*Source:** MON_GET_CONNECTION(NULL, #MEMBER#, 1).APPLICATION_NAME
Activity state
The current state of the activity or workload occurrence.
If there is no ACTIVITY_STATE from MON_GET_ACTIVITY, WORKLOAD_OCCURRENCE_STATE in MON_GET_CONNECTION will be used instead.
*Source:**
MON_GET_CONNECTION(NULL, #MEMBER#, 1).WORKLOAD_OCCURRENCE_STATE
MON_GET_ACTIVITY(NULL, #MEMBER#).ACTIVITY_STATE
Elapsed time
The elapsed time from the activity began doing work on the member.
*Source:**
MON_GET_ACTIVITY(NULL, #MEMBER#).LOCAL_START_TIME
Last request type
The type of the last request completed by the application.
*Source:** MON_GET_CONNECTION(NULL, #MEMBER#, 1).LAST_REQUEST_TYPE
Activity type
Possible values are as follows:
- CALL
- DDL
- LOAD
- OTHER
- READ_DML
- WRITE_DML
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).ACTIVITY_TYPE
Rows read
The number of rows read from the table.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).SUM(ROWS_READ)
Rows returned
The number of rows that have been selected and returned to the application.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).SUM(ROWS_RETURNED)
Direct reads
The number of read operations that do not use the buffer pool.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).SUM(DIRECT_READS)
Direct writes
The number of write operations that do not use the buffer pool.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).SUM(DIRECT_WRITES)
Sec num
The internal section number in the package for a static SQL statement.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).SECTION_NUMBER
Cost estimate
Estimated cost for a query, as determined by the SQL compiler.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).QUERY_COST_ESTIMATE
Card estimate
An estimate of the number of rows that will be returned by a query.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).QUERY_CARD_ESTIMATE
Db user
The current authorization ID for the session being used by this application.
*Source:** MON_GET_CONNECTION(NULL, #MEMBER#, 1).SESSION_AUTH_ID
Uow ID
The unit of work identifier. The unit of work ID is unique within an application handle.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).UOW_ID
Activity ID
Counter which uniquely identifies an activity for an application within a given unit of work.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).ACTIVITY_ID
Stmt text
The first 18 character of SQL statement.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).STMT_TEXT
Complete text
Complete text if SQL statement.
Source: MON_GET_ACTIVITY(NULL, #MEMBER#).STMT_TEXT