Oracle教程 2023-02-24

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

本站中文解释

列

Oracle视图V$CON_SYSMETRIC是V$SYSSTAT的一部分，它提供了更多系统指标的详细信息。它主要用于确定Oracle数据库实例的状态及表现，便于数据库DBA及开发者进行各种优化、诊断及性能调优。

V$CON_SYSMETRIC内有许多数据库工作细节，这些信息反映了当前活动带来的影响，包括活动事务数量、数据库死锁情况以及网络流量等多种统计结果。V$CON_SYSMETRIC还可以帮助DBA或开发者根据每个连接的当前活动实时监控每个进程的占用资源，及时发现异常情况，从而更有效地解决数据库性能问题。

使用方式：

可以通过执行以下SQL语句查看V$CON_SYSMETRIC视图获取某个连接的系统指标信息：

SELECT *
FROM V$CON_SYSMETRIC
WHERE CON_ID = ;

官方英文解释

V$CON_SYSMETRIC displays the system metric values captured for the most current time interval for the PDB long duration (60-second) system metrics.

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.

本站中文解释

官方英文解释

相关推荐