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) 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