Oracle 视图 V$METRIC_HISTORY 官方解释,作用,如何使用详细说明

本站中文解释

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

DATE

Begin time of the interval

END_TIME

DATE

End time of the interval

INTSIZE_CSEC

NUMBER

Interval size (in hundredths of a second)

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

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 V$METRIC_HISTORY 官方解释,作用,如何使用详细说明