Reports the identification number of the active stored procedure.
11.0 and later
Key
No
SMC_NAME_ACT_STP_DB_ID
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 |
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 |
VALUE_ SAMPLE |
VALUE_ SESSION |
RATE_ SAMPLE |
RATE_ SESSION |
AVG_ SAMPLE |
AVG_ SESSION |
|---|---|---|---|---|---|
LONG |
