-
I am little confused about the Force and Similar values for this parameter.
According to Oracle Docs this is what they mean. But doesnt it mean the same thing.
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.
-
Ronnie,
Cursor_sharing=SIMILAR is to be used when running on 9i, if I am not mistaken.
FORCE and EXACT (8i) but be very careful when using FORCE.
I had a bad experience using this parameter set to FORCE. I had to change it to EXACT
which is the default.
hope this help
