1.46 CURSOR_SHARING


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


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