SMC_NAME_STP_NUM_TIMES_EXECUTED

Description

Reports the number of times a stored procedure, or a line in a stored procedure, was executed.

Version compatibility

11.0 and later

Data item type

Result

Server level

No

Required keys

SMC_NAME_ACT_STP_DB_ID, SMC_NAME_ACT_STP_ID

Optional keys

SMC_NAME_SPID, SMC_NAME_STP_STMT_NUM, SMC_NAME_STP_LINE_NUM

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG

LONG

DOUBLE

DOUBLE