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

See Also:

“V$SESSTAT”


数据运维技术 » Oracle 视图 V$SQL_MONITOR_SESSTAT 官方解释,作用,如何使用详细说明