Reports the byte offset to the beginning of a statement within the query batch or stored procedure being executed for a particular process. If both CUR_STMT_ACT_STP_DB_ID is equal to 0 and CUR_STMT_ACT_STP_ID is equal to 0, then the statement is the currently executing SQL statement in the query batch. Otherwise, the statement is the currently executing SQL statement is in the stored procedure uniquely identified by these two IDs (above).
11.5 and later
Result
No
SMC_NAME_SPID
None
VALUE_ SAMPLE |
VALUE_ SESSION |
RATE_ SAMPLE |
RATE_ SESSION |
AVG_ SAMPLE |
AVG_ SESSION |
|---|---|---|---|---|---|
LONG |
