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 |
