CURSOR_SHARING

Parameter type:	String
Syntax:	CURSOR_SHARING = {FORCE | EXACT}
Parameter class:	Dynamic. Scope = ALTER SESSION, ALTER SYSTEM.
Default value:	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.