SMC_NAME_CUR_STMT_ACT_STP_ID

Description

Reports the ID of the stored procedure (including triggers, a special kind of stored procedure) that contains the currently executing SQL statement for a particular process. If the currently executing SQL statement is not contained in a stored procedure, this ID is zero.

Version compatibility

11.5 and later

Data item type

Result

Server level

No

Required keys

SMC_NAME_SPID

Optional keys

None

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG