9.49 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 of the handle to the parent for this cursor |
|
|
Hash value of the parent statement in the library cache |
|
|
SQL identifier of the parent cursor in the library cache |
|
|
Number of the child cursor being monitored |
|
|
Bucket number of the monitoring histogram |
|
|
Value in this bucket of the histogram |
|
|
The ID of the container to which the data pertains. Possible values include:
|