8.81 V$METRIC_HISTORY
V$METRIC_HISTORY
displays all the available statistic values for the complete set of metrics captured by the Automatic Workload Repository (AWR) infrastructure.
Column | Datatype | Description |
---|---|---|
|
|
Begin time of the interval |
|
|
End time of the interval |
|
|
Interval size (in hundredths of a second) |
|
|
Metric Group ID. Refer to the |
|
|
Entity ID for the metric in question. The value of the Entity ID depends upon the metric group. (See the table in the description of |
|
|
Entity Sequence number for the metric in question. The value of the Entity Sequence depends upon the metric group. (See the table in the description of |
|
|
Metric ID |
|
|
Metric Name. This is the statistic that is captured for the entity. |
|
|
Value of the statistic between |
|
|
Unit for the |
|
|
The ID of the container to which the data pertains. Possible values include:
|