SMC_NAME_OBJ_ID

Description

Reports the identification number of a database object where the object returned is either a table or a stored procedure.

Version compatibility

11.0 and later

Data item type

Key

Server level

No

Required keys

SMC_NAME_DB_ID

Result data items that require this key

SMC_NAME_BLOCKING_SPID

SMC_NAME_DEMAND_LOCK

SMC_NAME_LOCKS_BEING_BLOCKED_CNT

SMC_NAME_OBJ_NAME

SMC_NAME_OBJ_TYPE

SMC_NAME_OWNER_NAME

SMC_NAME_TIME_WAITED_ON_LOCK

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

If you create a view using the SMC_NAME_OBJ_ID data item, you might see negative numbers as object IDs. Negative object IDs are an accurate reporting of IDs as assigned by Adaptive Server.

Monitor Server reports on all activity, including activity on temporary tables that Adaptive Server creates to perform a complex query. The object IDs that Adaptive Server assigns to temporary tables can be positive or negative. The object ID that was assigned by Adaptive Server is reported.