Oracle教程 2023-02-24

Oracle 视图 DBA_HIST_METRIC_NAME 官方解释，作用，如何使用详细说明

Oracle 视图DBA_HIST_METRIC_NAME表示存储AWR性能指标名称的数据字典视图。它包含有关AWR指标定义和积累报告方法的各种信息。

它被用于提供历史记录和更好地模块化报告，使得AWR报告更加清晰、富含信息和易于理解。可以使用该视图来获取AWR的指标的类型、单位、元数据和有关它们的积累报告方法。

该视图可以通过如下查询访问:

SELECT * FROM DBA_HIST_METRIC_NAME;

DBA_HIST_METRIC_NAME describes attributes of the set of RDBMS metrics.

This view contains a snapshot of V$METRICNAME.

Column	Datatype	NULL	Description
`DBID`	`NUMBER`	`NOT NULL`	Database ID
`GROUP_ID`	`NUMBER`	`NOT NULL`	Metric Group ID
`GROUP_NAME`	`VARCHAR2(64)`		Metric group name
`METRIC_ID`	`NUMBER`	`NOT NULL`	Metric ID
`METRIC_NAME`	`VARCHAR2(64)`	`NOT NULL`	Metric name
`METRIC_UNIT`	`VARCHAR2(64)`	`NOT NULL`	Unit of measurement
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. 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