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 |