SMC_NAME_ACT_STP_ID

Description

Reports the identification number of the active stored procedure.

Version compatibility

11.0 and later

Data item type

Key

Server level

No

Required keys

SMC_NAME_ACT_STP_DB_ID

Result data items that require this key

SMC_NAME_ACT_ STP_NAME

SMC_NAME_ACT_ STP_OWNER_NAME

SMC_NAME_STP_CPU_TIME

SMC_NAME_STP_ELAPSED_TIME

SMC_NAME_STP_EXECUTION_CLASS

SMC_NAME_STP_LINE_TEXT

SMC_NAME_STP_NUM_TIMES_EXECUTED

Result data items for which this key is optional

SMC_NAME_LOCKS_GRANTED_IMMED

SMC_NAME_LOCKS_GRANTED_WAITED

SMC_NAME_LOCKS_NOT_GRANTED

SMC_NAME_PAGE_INDEX_LOGICAL_READ

SMC_NAME_PAGE_INDEX_PHYSICAL_READ

SMC_NAME_PAGE_HIT_PCT

SMC_NAME_PAGE_IO

SMC_NAME_PAGE_LOGICAL_READ

SMC_NAME_PAGE_PHYSICAL_READ

SMC_NAME_PAGE_WRITE

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG