cursor_sharing
CURSOR_SHARING
Property | Description |
---|---|
Parameter type | String |
Syntax | CURSOR_SHARING = { EXACT | FORCE } |
Default value | EXACT |
Modifiable | ALTER SESSION , ALTER SYSTEM |
Basic | No |
CURSOR_SHARING
determines what kind of SQL statements can share the same cursors.
Values:
-
FORCE
Allows the creation of a new cursor if sharing an existing cursor, or if the cursor plan is not optimal.
-
EXACT
Only allows statements with identical text to share the same cursor.
Notes:
-
If you set
CURSOR_SHARING
, then Oracle recommends theFORCE
setting unless you are in a DSS environment. -
The value of the
CURSOR_SHARING
parameter has performance implications. Refer to Oracle Database Performance Tuning Guide before setting this parameter.
-