Oracle教程 2023-02-24

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

Oracle视图V$SQL_MONITOR_SESSTAT是一个动态性能视图，用于监控正在运行的SQL语句所使用的统计信息，反映每个会话执行该查询所需的记录数和时间。

该视图使用方法是：通过查询V$SQL_MONITOR_SESSTAT视图，查看某一会话在运行的SQL语句的统计信息，包括该会话执行的SQL的执行的次数、事务中使用的内存、过程中执行的操作等，这样，就能更好地监控和优化会话的SQL语句运行状态。

V$SQL_MONITOR_SESSTAT displays information about statistics that are exposed in V$SESSTAT.

Column	Datatype	Description
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data
`KEY`	`NUMBER`	Artificial join key to efficiently join with other database operation views
`STATISTIC#`	`NUMBER`	Statistic number
`VALUE`	`NUMBER`	Value associated with the statistic