Oracle 视图 V$CON_SYSSTAT 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$CON_SYSSTAT用于查看联机模式 (OTM) 期间各连接或会话消耗的资源，此视图记录了单个客户端会话消耗系统资源的状态信息。
该视图汇总了会话级、客户端连接级和服务器端连接级的数据，包括会话的用户 ID 和密码，连接的登录名、服务名和客户机名，以及服务端进程 ID、 服务端进程 PGA 内存、请求的有效工作区数量等等。
要查询V$CON_SYSSTAT视图，可以使用以下SQL语句：
SELECT * FROM V$CON_SYSSTAT;
上述SQL语句将为您提供各个连接会话消耗的资源状态信息。
官方英文解释
V$CON_SYSSTAT displays system statistics, including OLAP kernel statistics for the container from which it is queried. To find the name of the statistic associated with each statistic number (STATISTIC#), query the V$STATNAME view.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Statistic number Note: Statistics numbers are not guaranteed to remain constant from one release to another. Therefore, you should rely on the statistics name rather than its number in your applications. |
|
|
|
Statistic name. You can get a complete listing of statistic names by querying the |
|
|
|
A number representing one or more statistics class. The following class numbers are additive:
|
|
|
|
Statistic value |
|
|
|
Identifier of the statistic |
|
|
|
When queried from a non-CDB, the statistics in that instance are returned, and the When queried from the root of a CDB, the statistics in every container are returned, and the When queried from a PDB, statistics in that PDB are returned, and the |
See Also:
“V$STATNAME” and “Statistics Descriptions”
