Oracle教程 2023-02-24

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

本站中文解释

Oracle视图是在Oracle数据库中定义的表。它们提供了一种查看数据库内容的方式，而不必访问数据库存储表或表示记录集合的文件。

DBA_HIST_CON_SYSMETRIC_HIST是一个系统指标历史度量视图，它检索指标的历史值，这些值是在内存中维护的。它的参数包括诊断基线，指标阀值，指标类型和时间戳。

可以通过该视图查看数据库性能的变化，特定指标的异常变化，和不稳定的性能变化的因素，以及汇总指标数据以进行性能分析。可以使用SQL命令来访问该视图并查询相关信息，比如：SELECT * FROM DBA_HIST_CON_SYSMETRIC_HIST WHERE METRIC_NAME=’Reads per second’。

官方英文解释

DBA_HIST_CON_SYSMETRIC_HIST externalizes all available history of the system metric values for the entire set of data kept in the database. This view contains snapshots of V$CON_SYSMETRIC_HISTORY.

Note:

This view is not populated and is reserved for future use.

Column	Datatype	Description
`SNAP_ID`	`NUMBER`	Unique snapshot ID
`DBID`	`NUMBER`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	Instance number for the snapshot
`BEGIN_TIME`	`DATE`	Begin time of the interval
`END_TIME`	`DATE`	End time of the interval
`INTSIZE`	`NUMBER`	Interval size (in hundredths of a second)
`GROUP_ID`	`NUMBER`	Group ID
`METRIC_ID`	`NUMBER`	Metric ID
`METRIC_NAME`	`VARCHAR2(64)`	Metric name
`VALUE`	`NUMBER`	Metric value
`METRIC_UNIT`	`VARCHAR2(64)`	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: 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 in 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.

本站中文解释

官方英文解释

相关推荐