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

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® Database Reference 11g Release 2 (11.2)
Initialization Parameters
Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to XS_SESSION_ROLES
Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO
Dynamic Performance (V$) Views: V$INDEXED_FIXED_COLUMN to V$RULE_SET_AGGREGATE_STATS
Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$XSTREAM_TRANSACTION
Database Limits
SQL Scripts
Oracle Wait Events
Oracle Enqueue Names
Statistics Descriptions
Background Processes

New and changed documents:

HTML

PDF