1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. CURSOR_SHARING

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