本站中文解释
V$METRIC_HISTORY 表是Oracle数据库内部视图，用于显示最近历史指标数据。它保存了此数据，以供来自某些内部进程的数据分析。
V$METRIC_HISTORY 的用途是可以捕捉和查看监控和管理指标。它用于检测等待事件，临时文件占用，性能，资源使用等信息，以便实现监控和调优。
使用方法：
1、可以使用SQL来查看V$METRIC_HISTORY表，例如：
SELECT * FROM V$METRIC_HISTORY;
2、可以使用EM Cloud表格来查看V$METRIC_HISTORY，也可以使用Oracle的数据库建议系统来检查内部表。
3、还可以使用其他第三方工具来诊断数据库性能方面的情况。通过使用 Oracle Database Exadata Cloud Service，可以查看这些指标的可视化数据。
官方英文解释
V$METRIC_HISTORY displays all the available 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 table in the description of |
|
|
|
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 |
|
|
|
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:
|
