Reports the process identification number. Views that contain SMC_NAME_SPID only report on processes that are active as of the end of the sample period. SMC_NAME_SPID is mutually exclusive with SMC_NAME_APPLICATION_NAME in a view.
11.0 and later
Key
No
SMC_NAME_BLOCKING_SPID |
SMC_NAME_CONNECT_TIME |
SMC_NAME_CPU_PCT |
SMC_NAME_CPU_TIME |
SMC_NAME_CUR_APP_NAME |
SMC_NAME_CUR_ENGINE |
SMC_NAME_CUR_EXECUTION_CLASS |
SMC_NAME_CUR_PROC_STATE |
SMC_NAME_CUR_STMT_ACT_STP_DB_NAME |
SMC_NAME_CUR_STMT_ACT_STP_NAME |
SMC_NAME_CUR_STMT_ACT_STP_OWNER_NAME |
SMC_NAME_CUR_STMT_ACT_STP_TEXT |
SMC_NAME_CUR_STMT_BATCH_TEXT |
SMC_NAME_CUR_STMT_CPU_TIME |
SMC_NAME_CUR_STMT_ELAPSED_TIME |
SMC_NAME_CUR_STMT_LINE_NUM |
SMC_NAME_CUR_STMT_LOCKS_GRANTED_IMMED |
SMC_NAME_CUR_STMT_LOCKS_GRANTED_WAITED |
SMC_NAME_CUR_STMT_LOCKS_NOT_GRANTED |
SMC_NAME_CUR_STMT_PAGE_IO_CNT |
SMC_NAME_CUR_STMT_PAGE_CACHE_READ_CNT |
SMC_NAME_CUR_STMT_PAGE_PHYSICAL_READ_CNT |
SMC_NAME_CUR_STMT_PAGE_WRITE_CNT |
SMC_NAME_CUR_STMT_QUERY_PLAN_TEXT |
SMC_NAME_CUR_STMT_START_TIME |
SMC_NAME_CUR_STMT_TEXT_BYTE_OFFSET |
SMC_NAME_DEMAND_LOCK |
SMC_NAME_HOST_NAME |
SMC_NAME_KPID |
SMC_NAME_LOCKS_BEING_BLOCKED_CNT |
SMC_NAME_LOGIN_NAME |
SMC_NAME_TIME_WAITED_ON_LOCK |
SMC_NAME_LOCK_CNT |
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_LOGICAL_READ |
SMC_NAME_PAGE_PHYSICAL_READ |
SMC_NAME_PAGE_WRITE |
SMC_NAME_STP_CPU_TIME |
SMC_NAME_STP_NUM_TIMES_EXECUTED |
VALUE_ SAMPLE |
VALUE_ SESSION |
RATE_ SAMPLE |
RATE_ SESSION |
AVG_ SAMPLE |
AVG_ SESSION |
|---|---|---|---|---|---|
LONG |
