Oracle 视图 V$METRIC 官方解释，作用，如何使用详细说明
本站中文解释
V$METRIC视图用于查看基于实例管理视图和动态性能视图中生成的度量值。它可以按照活动和会话方式显示统计信息，并查看当前正在运行的摘要信息和活动的状态，以及可用的信息的采样间隔。
要使用V$METRIC视图，需要先使用实例管理视图收集统计信息，然后再应用V$METRIC视图。要使用V$METRIC，先进入sqlplus，输入and用户密码，然后输入下面的语句：
select * from v$metric;
这将使用V$METRIC视图，显示出实例管理视图和动态性能视图收集的度量值。然后可以根据你需要的条件来编写SQL语句过滤出你想要看到的信息，从而进行查询。
官方英文解释
V$METRIC displays the most recent 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 following table for an explanation of possible values.) |
|
| 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 |
|
| 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:
|
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 |
编辑：一起学习网
标签：视图,实例,度量,统计信息,要使