OBJECT_METRICS table

The OBJECT_METRICS table contains runtime statistics collected for each object referenced in a specific execution of a section (identified by executable ID) at a specific time (identified by execution time).

If object statistics are collected on multiple database members, there will be a row per database member for each object. If it is a partitioned object, then there will be one row per data partition.

The OBJECT_METRICS table is populated only if section actuals were captured by the activity event monitor.

Table 1. OBJECT_METRICS table
Column Name	Data Type	Nullable?	Key?	Description
EXECUTABLE_ID	VARCHAR(32) FOR BIT DATA	No	PK	A binary token generated on the data server that uniquely identifies the SQL statement section that was executed.
EXECUTION_TIME	TIMESTAMP	No	PK	Time the section started execution.
OBJECT_SCHEMA	VARCHAR(128)	No	PK	Schema to which this object belongs.
OBJECT_NAME	VARCHAR(128)	No	PK	Name of the object.
OBJECT_TYPE	CHAR(2)	No	PK	Descriptive label for the type of object. Possible values: IX Index DP Data partitioned table TA Table PI Physical XML Index LI Partitioned index LP Partitioned physical XML index
MEMBER	SMALLINT	No	PK	The database member where the object statistics is collected.
DATA_PARTITION_ID	INTEGER	No	PK	The identifier of the data partition for which information is returned . This element is applicable only to partitioned tables or indexes.
ROWS_READ	BIGINT	Yes	No	The total number of rows read.
ROWS_INSERTED	BIGINT	Yes	No	The total number of row insertions attempted.
ROWS_UPDATED	BIGINT	Yes	No	The total number of row updates attempted.
ROWS_DELETED	BIGINT	Yes	No	The total number of row deletions attempted.
OVERFLOW_CREATES	BIGINT	Yes	No	The number of overflowed rows created on this table object.
OVERFLOW_ACCESSES	BIGINT	Yes	No	The number of accesses (reads and writes) to overflowed rows of this table object.
LOCK_WAIT_TIME	BIGINT	Yes	No	The total elapsed time spent waiting for local locks. The value is given in milliseconds.
LOCK_WAIT_TIME_GLOBAL	BIGINT	Yes	No	The total elapsed time spent waiting for global locks. The value is given in milliseconds.
LOCK_WAITS	BIGINT	Yes	No	The total number of times that the section waited on locks.
LOCK_WAITS_GLOBAL	BIGINT	Yes	No	The total number of times that the section waited on global locks.
LOCK_ESCALS	BIGINT	Yes	No	The total number of times that local locks have been escalated.
LOCK_ESCALS_GLOBAL	BIGINT	Yes	No	The total number of times that global locks have been escalated.
DIRECT_WRITES	BIGINT	Yes	No	The total number of write operations that do not use a buffer pool.
DIRECT_WRITE_REQS	BIGINT	Yes	No	The total number of requests to perform a direct write of one or more sectors of data.
DIRECT_READS	BIGINT	Yes	No	The total number of read operations that do not use a buffer pool.
DIRECT_READ_REQS	BIGINT	Yes	No	The total number of requests to perform a direct read of one or more sectors of data.
OBJECT_DATA_L_READS	BIGINT	Yes	No	Indicates the number of data pages which have been requested for the table (logical).
OBJECT_DATA_P_READS	BIGINT	Yes	No	Indicates the number of data pages read in for the table (physical).
OBJECT_DATA_GBP_L_READS	BIGINT	Yes	No	The number of times a Group Buffer Pool (GBP) dependent data page was attempted to be read for the table from the group buffer pool because the page was either invalid or not present in the Local Buffer Pool (LBP).
OBJECT_DATA_GBP_P_READS	BIGINT	Yes	No	The number of times a Group Buffer Pool (GBP) dependent data page was read for the table into the local buffer pool from disk because it was not found in the group buffer pool.
OBJECT_DATA_GBP_INVALID_PAGES	BIGINT	Yes	No	The number of times a data page for XML Storage (XDAs) was attempted to be read for the table from the group buffer pool because the page was invalid in the local buffer pool.
OBJECT_DATA_LBP_PAGES_FOUND	BIGINT	Yes	No	The number of times a data page for the table was present in the local buffer pool.
OBJECT_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP	BIGINT	Yes	No	The number of group buffer pool (GBP) independent data pages found in the local buffer pool (LBP) by the agent.
OBJECT_XDA_L_READS	BIGINT	Yes	No	Indicates the number of data pages for XML Storage (XDAs) which have been requested for the table (logical).
OBJECT_XDA_P_READS	BIGINT	Yes	No	Indicates the number of data pages for XML storage (XDAs) read in for the table (physical).
OBJECT_XDA_GBP_L_READS	BIGINT	Yes	No	The number of times a Group Buffer Pool (GBP) dependent data page for XML Storage (XDAs) was attempted to be read for the table from the group buffer pool because the page was either invalid or not present in the Local Buffer Pool (LBP).
OBJECT_XDA_GBP_P_READS	BIGINT	Yes	No	The number of times a Group Buffer Pool (GBP) dependent data page for XML Storage (XDAs) was read for the table into the local buffer pool from disk because it was not found in the GBP.
OBJECT_XDA_GBP_INVALID_PAGES	BIGINT	Yes	No	The number of times a data page was attempted to be read for the table from the group buffer pool because the page was invalid in the local buffer pool.
OBJECT_XDA_LBP_PAGES_FOUND	BIGINT	Yes	No	The number of times a XML Storage (XDAs) data page for the table was present in the local buffer pool.
OBJECT_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP	BIGINT	Yes	No	The number of group buffer pool (GBP) independent XML storage object (XDA) data pages found in the local buffer pool (LBP) by the agent.
OBJECT_INDEX_L_READS	BIGINT	Yes	No	Indicates the number of index pages which have been requested for the index (logical).
OBJECT_INDEX_P_READS	BIGINT	Yes	No	Indicates the number of index pages read in for the index (physical).
OBJECT_INDEX_GBP_L_READS	BIGINT	Yes	No	The number of times a Group Buffer Pool (GBP) dependent index page was attempted to be read for the index from the group buffer pool because the page was either invalid or not present in the Local Buffer Pool (LBP).
OBJECT_INDEX_GBP_P_READS	BIGINT	Yes	No	The number of times a Group Buffer Pool (GBP) dependent index page was read for the index into the local buffer pool from disk because it was not found in the GBP.
OBJECT_INDEX_GBP_INVALID_PAGES	BIGINT	Yes	No	The number of times an index page was attempted to be read for the index from the group buffer pool because the page was invalid in the local buffer pool.
OBJECT_INDEX_LBP_PAGES_FOUND	BIGINT	Yes	No	The number of times an index page for the index was present in the local buffer pool.
OBJECT_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP	BIGINT	Yes	No	The number of group buffer pool (GBP) independent index pages found in the local buffer pool (LBP) by the agent.
OBJECT_COL_L_READS	BIGINT	Yes	No	The number of column-organized pages that are logically read from the buffer pool for a table.
OBJECT_COL_P_READS	BIGINT	Yes	No	The number of column-organized pages that are physically read for a table.
OBJECT_COL_GBP_L_READS	BIGINT	Yes	No	The number of times that a group buffer pool (GBP) dependent column-organized page is requested from the GBP for a table. The page is requested because a valid version of the page does not exist in the local buffer pool (LBP).
OBJECT_COL_GBP_P_READS	BIGINT	Yes	No	The number of times that a group buffer pool (GBP) dependent column-organized page is read into the local buffer pool (LBP) from disk for a table. The page is read from disk into the LBP because the page is not in the GBP.
OBJECT_COL_GBP_INVALID_PAGES	BIGINT	Yes	No	The number of times that a column-organized page is requested from the group buffer pool (GBP) for a table. The page is requested because the version of the page in the local buffer pool (LBP) is invalid.
OBJECT_COL_LBP_PAGES_FOUND	BIGINT	Yes	No	The number of times that a column-organized page for a table is present in the local buffer pool (LBP).
OBJECT_COL_GBP_INDEP_PAGES_FOUND_IN_LBP	BIGINT	Yes	No	The number of group buffer pool (GBP) independent column-organized pages found in a local buffer pool (LBP) by an agent.
OBJECT_DATA_CACHING_TIER_L_READS	BIGINT	Yes	No	The total number of data-type pages that are synchronously read by agents from caching tier and remote storage for the table.
OBJECT_DATA_CACHING_TIER_PAGES_FOUND	BIGINT	Yes	No	The number of times that data-type pages were found in caching tier for the table.
OBJECT_DATA_CACHING_TIER_GBP_INVALID_PAGES	BIGINT	Yes	No	Reserved for future use.
OBJECT_DATA_CACHING_TIER_GBP_INDEP_PAGES_FOUND	BIGINT	Yes	No	Reserved for future use.
OBJECT_XDA_CACHING_TIER_L_READS	BIGINT	Yes	No	The total number of XML data-type pages that are synchronously read by agents from caching tier and remote storage for the table.
OBJECT_XDA_CACHING_TIER_PAGES_FOUND	BIGINT	Yes	No	The number of times that XML data-type pages were found in caching tier for the table.
OBJECT_XDA_CACHING_TIER_GBP_INVALID_PAGES	BIGINT	Yes	No	Reserved for future use.
OBJECT_XDA_CACHING_TIER_GBP_INDEP_PAGES_FOUND	BIGINT	Yes	No	Reserved for future use.
OBJECT_INDEX_CACHING_TIER_L_READS	BIGINT	Yes	No	The total number of index-type pages that are synchronously read by agents from caching tier and remote storage for the table.
OBJECT_INDEX_CACHING_TIER_PAGES_FOUND	BIGINT	Yes	No	The number of times that index-type pages were found in caching tier for the table.
OBJECT_INDEX_CACHING_TIER_GBP_INVALID_PAGES	BIGINT	Yes	No	Reserved for future use.
OBJECT_INDEX_CACHING_TIER_GBP_INDEP_PAGES_FOUND	BIGINT	Yes	No	Reserved for future use.
OBJECT_COL_CACHING_TIER_L_READS	BIGINT	Yes	No	The total number of columnar-type pages that are synchronously read by agents from caching tier and remote storage for the table.
OBJECT_COL_CACHING_TIER_PAGES_FOUND	BIGINT	Yes	No	The number of times that columnar-type pages were found in caching tier for the table.
OBJECT_COL_CACHING_TIER_GBP_INVALID_PAGES	BIGINT	Yes	No	Reserved for future use.
OBJECT_COL_CACHING_TIER_GBP_INDEP_PAGES_FOUND	BIGINT	Yes	No	Reserved for future use.
EXT_TABLE_RECV_WAIT_TIME	BIGINT	Yes	No	Total time the agent spent waiting for the external table readers to read and process data from external tables. The value is given in milliseconds.
EXT_TABLE_RECVS_TOTAL	BIGINT	Yes	No	Total number of buffers that were received by the agent from the external table readers.
EXT_TABLE_RECV_VOLUME	BIGINT	Yes	No	Total volume that were received by the agent from the external table readers. The value is given in bytes.
EXT_TABLE_READ_VOLUME	BIGINT	Yes	No	Total volume that was read by the external table reader from physical devices, such as disks. The value is given in bytes.
EXT_TABLE_SEND_WAIT_TIME	BIGINT	Yes	No	Total time the agent spent waiting for the sent data to be processed and written by the external table writers. The value is given in milliseconds.
EXT_TABLE_SENDS_TOTAL	BIGINT	Yes	No	Total number of buffers that were sent to the external table writers.
EXT_TABLE_SEND_VOLUME	BIGINT	Yes	No	Total volume that was sent by the agent to the external table writers. The value is given in bytes.
EXT_TABLE_WRITE_VOLUME	BIGINT	Yes	No	Total volume that was written by the external writers to physical devices, such as disks. The value is given in bytes.
CACHING_TIER_DIRECT_READS	BIGINT	YES	NO	The number of read operations for the table that used the caching tier only and didn't need to fetch the page from the remote storage layer.
CACHING_TIER_DIRECT_READ_TIME	BIGINT	YES	NO	The elapsed time in milliseconds required to perform direct reads serviced from the caching tier only and didn't need to fetch pages from the remote storage layer.
CACHING_TIER_DIRECT_READ_REQS	BIGINT	YES	NO	The number of read requests that for the table were satisfied from the caching tier only and didn't need to fetch the page from the remote storage layer.
CACHING_TIER_PAGE_READ_TIME	BIGINT	YES	NO	Total amount of time in milliseconds spent reading in pages of all types from the caching tier. This excludes time spent reading from remote storage.