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 Reserved for future use.
OBJECT_DATA_
CACHING_TIER_
PAGES_FOUND		 BIGINT Yes No Reserved for future use.
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 Reserved for future use.
OBJECT_XDA_
CACHING_TIER_
PAGES_FOUND		 BIGINT Yes No Reserved for future use.
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 Reserved for future use.
OBJECT_INDEX_
CACHING_TIER_
PAGES_FOUND		 BIGINT Yes No Reserved for future use.
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 Reserved for future use.
OBJECT_COL_
CACHING_TIER_
PAGES_FOUND		 BIGINT Yes No Reserved for future use.
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.