String 

CURSOR_SHARING = {FORCE | EXACT} 

Dynamic. Scope = ALTER SESSION, ALTER SYSTEM. 

EXACT 

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

• EXACT causes only identical SQL statements to share a cursor.

• FORCE forces statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect the meaning of the statement.

Note: Forcing cursor sharing among similar (but not identical) statements can have unexpected results in some DSS applications and if your applications use stored outlines.

See Also: Oracle8i Designing and Tuning for Performance for information on setting this parameter in these and other environments.