Oracle教程

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

本站中文解释

Oracle视图V$SQL_CS_STATISTICS是一个动态性能视图，用于报告在某一暂时快照期间执行的SQL语句的查询转换统计。

V$SQL_CS_STATISTICS用于报告关于在某一时间快照之前的执行的SQL语句的语句性能的统计信息，其中包括语句驱动的查询转换数量，被使用的查询转换的概要，平均查询次数，SQL语句解析次数等信息。V$SQL_CS_STATISTICS用于调整SQL语句，改善查询性能，监视包含语句执行频率的选项变化，以及记录SQL语句的用量(类似于SQL监控器的被记录的数据)。

V$SQL_CS_STATISTICS可以通过SQL语句进行查询，具体格式如下：

SELECT * FROM V$SQL_CS_STATISTICS;

官方英文解释

V$SQL_CS_STATISTICS contains the raw execution statistics used by the monitoring component of adaptive cursor sharing. A sample of the executions is monitored. This view exposes which executions were sampled, and what the statistics were for those executions. The statistics are cumulative for each distinct set of bind values.
Column Datatype Description

ADDRESS

RAW(4 | 8)

Address of the handle to the parent for this cursor

HASH_VALUE

NUMBER

Hash value of the parent statement in the library cache

SQL_ID

VARCHAR2(13)

SQL identifier of the parent cursor in the library cache

CHILD_NUMBER

NUMBER

Number of the child cursor being monitored

BIND_SET_HASH_VALUE

NUMBER

Hash of the values of the binds

PEEKED

VARCHAR2(1)

Indicates if this is the bind set used to build the cursor (Y) or not (N)

EXECUTIONS

NUMBER

Number of times this bind set has been executed and monitored

ROWS_PROCESSED

NUMBER

Cumulative number of rows processed by all row sources in the plan over all monitored executions with this bind set

BUFFER_GETS

NUMBER

Cumulative number of buffer gets over all monitored executions with this bind set

CPU_TIME

NUMBER

Cumulative CPU time (in microseconds) used by this cursor for monitored executions with this bind set

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


数据运维技术 » Oracle 视图 V$SQL_CS_STATISTICS 官方解释，作用，如何使用详细说明
分享到：

相关推荐