V$METRIC_HISTORY

Oracle 11gR1

V$METRIC_HISTORY displays all the available 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 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

Note:

1.

select * from V$METRIC_HISTORY;

BEGIN_TIME	END_TIME	INTSIZE _CSEC	GROUP _ID	ENTITY _ID	ENTITY_ SEQUENCE	METRIC _ID	METRIC_NAME	VALUE	METRIC _UNIT
2008-08-12 1:19:52 PM	2008-08-12 1:20:51 PM	5971	0	0	4294967295	0	Number of Sessions Waiting (Event)	0	Sessions
2008-08-12 1:19:52 PM	2008-08-12 1:20:51 PM	5971	0	0	4294967295	1	Total Time Waited	0	CentiSeconds
2008-08-12 1:19:52 PM	2008-08-12 1:20:51 PM	5971	0	0	4294967295	2	Total Wait Counts	0	Waits
2008-08-12 1:19:52 PM	2008-08-12 1:20:51 PM	5971	0	1	4294967295	0	Number of Sessions Waiting (Event)	1	Sessions
2008-08-12 1:19:52 PM	2008-08-12 1:20:51 PM	5971	0	1	4294967295	1	Total Time Waited	5871.1863	CentiSeconds

2. The following dictionary views provide information about server alerts:

• DBA_THRESHOLDS lists the threshold settings defined for the instance.
• DBA_OUTSTANDING_ALERTS describes the outstanding alerts in the database.
• DBA_ALERT_HISTORY lists a history of alerts that have been cleared.
• V$ALERT_TYPES provides information such as group and type for each alert.
• V$METRICNAME contains the names, identifiers, and other information about the system metrics.
• V$METRIC and V$METRIC_HISTORY views contain system-level metric values in memory.

Oracle dynamic performance views