V$METRIC

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