Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 29 of 220
Parameter type |
String |
Syntax |
|
Default value |
|
Parameter class |
Dynamic: |
CURSOR_SHARING
determines what kind of SQL statements can share the same cursors.
Values:
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.
SIMILAR
Causes statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect either the meaning of the statement or the degree to which the plan is optimized.
EXACT
Only allows statements with identical text to share the same cursor.
See Also:
Oracle9i Database Performance Guide and Reference for information on setting this parameter in these and other environments |
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|