V$METRIC displays the most recent statistic values for the complete set of metrics captured by the AWR infrastructure.
| Column | Datatype | Description |
|---|---|---|
BEGIN_TIME |
DATE |
Begin time for the metric value |
END_TIME |
DATE |
End time for the metric value |
INTSIZE_CSEC |
NUMBER |
Size of the time period |
GROUP_ID |
NUMBER |
Metric Group ID. Refer to the V$METRICNAME view for the name of the group. |
ENTITY_ID |
NUMBER |
Entity ID for the metric in question. The value of the Entity ID depends upon the metric group. (See the following table for an explanation of possible values.) |
ENTITY_SEQUENCE |
NUMBER |
Entity Sequence number for the metric in question. The value of the Entity Sequence depends upon the metric group. (See the following table for an explanation of possible values.) |
METRIC_ID |
NUMBER |
Metric ID |
METRIC_NAME |
VARCHAR2(64) |
Metric Name. This is the statistic that is captured for the entity. |
VALUE |
NUMBER |
Value of the statistic between BEGIN_TIME and END_TIME |
METRIC_UNIT |
VARCHAR2(64) |
Unit for the VALUE |
The following table describes what the ENTITY_ID and ENTITY_SEQUENCE are for each metric group:
| GID | Group NAME | Entity ID | Entity Sequence |
|---|---|---|---|
| 0 | Event Metrics | Event# | N/A |
| 1 | Event Class Metrics | Wait Class ID | N/A |
| 2 | System Metrics Long Duration | N/A | N/A |
| 3 | System Metrics Short Duration | N/A | N/A |
| 4 | Session Metrics Long Duration | Session ID | Serial# |
| 5 | Session Metrics Short Duration | Session ID | Serial# |
| 6 | Service Metrics | N/A | Service Hash |
| 7 | File Metrics Long Duration | File# | Creation Change# |
| 9 | Tablespace Metrics Long Duration | Tablespace# | N/A |
| 10 | Service Metrics (Short) | N/A | Service Hash |