Page tree

The process metrics data is contained in the metric and metric_detail tables within the database. There is no master table. The tables are created after process metrics data collection is configured. The metric_detail table has a foreign key relationship to the metric table.

The following two tables offer details about the fields in each process metrics table.

Fields in the metric table

Field

Description

ID

Unique record identifier of the metric and primary key

GRID_NAME

The name of the grid on which the process occurred for which the metric is recorded

PEER_NAME

The name of the peer where the process occurred for which the metric is recorded

START_TIME

Start time of the process or action whose information is recorded as a metric

CATEGORY

The type of metric being recorded

DESCRIPTION

Description of the process or action whose information is recorded as a metric

DURATION

Length of time the process or action took to finish

STATUS

Status of the process or action

ENTITY_ID

Unique identifier of the process or action

USER_ID

User name of the person or system who invoked the process or the action


Fields in the metric_detail table

Field

Description and sample values

ID

The unique record identifier and primary key

NAME

Metric for which the VALUE is captured

VALUE

Metric value that corresponds to the NAME attribute or item

METRIC_ID

Cross-referenced value for the ID in the metric table

SEQUENCE_NUM

Sequence number of the metric detail records of a metric record (internal use only)