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`	`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 table in the description of `V$METRIC` 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 table in the description of `V$METRIC` 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`
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data