CURSOR_SHARING

CURSOR_SHARING determines what type of SQL statements can share the same cursors. If this parameter is set to EXACT, only statements with identical text can share the same cursor. If this parameter is set to FORCE, statements that differ in some literals but are otherwise identical can share and reuse SQL cursors, unless the literals affect the meaning of the statement. Tests show that setting this parameter to a value of FORCE may improve consolidation and reporting performance significantly. This is because with this parameter set to FORCE, the Oracle database spends less time parsing SQL statements, and requires less memory.

Suggested setting for all releases prior to 11.1.2.2.300: FORCE

Suggested setting for releases 11.1.2.2.300 and later: EXACT