|Oracle® Database Reference
11g Release 2 (11.2)
Part Number E17110-04
CURSOR_SHARING determines what kind of SQL statements can share the same cursors.
Allows the creation of a new cursor if sharing an existing cursor, or if the cursor plan is not optimal.
Causes statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect either the meaning of the statement or the degree to which the plan is optimized.
Only allows statements with identical text to share the same cursor.
If you set
CURSOR_SHARING, then Oracle recommends the
FORCE setting unless you are in a DSS environment.
FORCE limits the growth of child cursors that can occur when the setting is
The value of the
CURSOR_SHARING parameter has performance implications. Refer to Oracle Database Performance Tuning Guide before setting this parameter.