SMC_NAME_ACT_STP_DB_ID

Description

Reports the database identification number of the active stored procedure.

Version compatibility

11.0 and later

Data item type

Key

Server level

No

Result data items that require this key

SMC_NAME_ACT_ STP_DB_NAME

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