Oracle教程 2023-02-24

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

V$CON_SYSMETRIC_HISTORY视图存储由Oracle Enterprise Manager获取的系统度量历史记录。它可以帮助数据库管理员了解以下内容：

1. 什么时候发生需要改变参数的错误；
2. 哪些资源使用多少；
3. 服务器上运行了多长时间；
4. 平均活动会话数和网络流量；
5. 数据库物理和逻辑结构的变化；
6. 资源监控例程的实施和运行质量。

要使用V$CON_SYSMETRIC_HISTORY视图，用户可以使用SELECT语句来检索所需的记录：

SELECT * FROM V$CON_SYSMETRIC_HISTORY;

用户还可以使用WHERE子句为搜索提供更深入的条件，以确定特定的资源使用情况：

SELECT resource_name, uptime_metric_value
FROM V$CON_SYSMETRIC_HISTORY
WHERE resource_name = ‘Database Uptime’;

V$CON_SYSMETRIC_HISTORY displays all PDB long duration (60-second with 1 hour history) system metric values available in the database.

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
`METRIC_ID`	`NUMBER`	Metric ID
`METRIC_NAME`	`VARCHAR2(64)`	Metric name
`VALUE`	`NUMBER`	Metric value
`METRIC_UNIT`	`VARCHAR2(64)`	Metric unit description
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: When queried from a non-CDB, the statistics for that instance are returned, and the `CON_ID` value is `0`. When queried from the root of a CDB, the statistics for every container are returned, and the `CON_ID` value indicates the container to which the statistics belong. When queried from a PDB, statistics from that PDB are returned, and the `CON_ID` value is the container ID for that PDB.