Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E17110-04
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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