V$METRICNAME

Oracle 11gR1

V$METRICNAME displays the mapping of the name of metrics to their metric ID.

Column	Datatype	Description
GROUP_ID	NUMBER	Metric group ID
GROUP_NAME	VARCHAR2(64)	Metric group name
METRIC_ID	NUMBER	Metric ID
METRIC_NAME	VARCHAR2(64)	Metric name
METRIC_UNIT	VARCHAR2(64)	Unit of measurement

Note:

1.

select * from V$METRICNAME order by group_id;

GROUP_ID	GROUP_NAME	METRIC_ID	METRIC_NAME	METRIC_UNIT
0	Event Metrics	0	Number of Sessions Waiting (Event)	Sessions
0	Event Metrics	1	Total Time Waited	CentiSeconds
0	Event Metrics	2	Total Wait Counts	Waits
1	Event Class Metrics	1000	Average Users Waiting Counts	Users
1	Event Class Metrics	1002	Total Wait Counts	Waits
1	Event Class Metrics	1003	Total Time Waited	CentiSeconds
1	Event Class Metrics	1001	Database Time Spent Waiting (%)	% (TimeWaited / DBTime)
2	System Metrics Long Duration	2130	DB Block Gets Per User Call	Blocks Per Call
2	System Metrics Long Duration	2131	Executions Per User Call	Executes Per Call
……

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