Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
|
Modifiable |
|
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.
See Also:
Oracle Database SQL Tuning Guide before setting the CURSOR_SHARING
parameter to learn about the performance implications