CURSOR_SHARING

CURSOR_SHARING determines what kind of SQL statements can share the same cursors.

Property	Description
Parameter type	String
Syntax	CURSOR_SHARING = { EXACT | FORCE }
Default value	EXACT
Modifiable	ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB	Yes
Basic	No

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 AI Database SQL Tuning Guide before setting the CURSOR_SHARING parameter to learn about the performance implications