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.

See Also:

Oracle Database Performance Tuning Guide before setting the CURSOR_SHARING parameter to learn about the performance implications