Oracle教程 2023-02-24

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

本站中文解释

Oracle V$CON_SYSMETRIC_SUMMARY 视图显示的是联合收集的系统指标和 Oracle 数据库应用程序关联定义的指标的综合。每个连接定义在连接池中，并且附有多个应用程序指标。

使用方法：

1. 查询应用程序指标

可以使用SELECT结构，以7字段格式检索V$CON_SYSMETRIC_SUMMARY视图的内容

SELECT SID,
POOL_ID,
METRIC_NAME,
VALUE_1,
VALUE_2,
VALUE_3,
VALUE_4
FROM V$CON_SYSMETRIC_SUMMARY
WHERE METRIC_NAME LIKE ‘%APPLICATION%’;

2. 查询系统指标

可以使用SELECT结构，以8字段格式检索V$CON_SYSMETRIC_SUMMARY视图的内容

SELECT SID,
POOL_ID,
METRIC_NAME,
TARGET_ID,
VALUE_1,
VALUE_2,
VALUE_3,
VALUE_4
FROM V$CON_SYSMETRIC_SUMMARY
WHERE METRIC_NAME NOT LIKE ‘%APPLICATION%’;

官方英文解释

V$CON_SYSMETRIC_SUMMARY displays a summary of all system metric values for the PDB long-duration system metrics. The average, maximum value, minimum value, and the value of one standard deviation for the last hour are displayed for each metric item.

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
`NUM_INTERVAL`	`NUMBER`	Number of intervals observed
`MAXVAL`	`NUMBER`	Maximum value observed
`MINVAL`	`NUMBER`	Minimum value observed
`AVERAGE`	`NUMBER`	Average value over the period
`STANDARD_DEVIATION`	`NUMBER`	One standard deviation
`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.

本站中文解释

官方英文解释

相关推荐