../E40402-16.epub /> ../E40402-16.mobi />

V$SQL_CS_HISTOGRAM

V$SQL_CS_HISTOGRAM summarizes the monitoring information stored by adaptive cursor sharing. This information is used to decide whether to enable extended cursor sharing for a query. It is stored in a histogram, whose bucket's contents are exposed by this view.

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
BUCKET_ID NUMBER Bucket number of the monitoring histogram
COUNT NUMBER Value in this bucket of the histogram