First page Back Continue Last page Overview Graphics
Cursor Sharing…
CURSOR_SHARING = SIMILAR initialization parameter
- Replaces literals with bind variables only if plan will not change
Notes:
To complement the CURSOR_SHARING =FORCE parameter, Oracle9i adds the SIMILAR parameter.
Review: CURSOR_SHARING=FORCE causes CBO to replace all literals with bind variables, also called auto-binding. This can be useful when you have applications that cannot be rewritten to incorporate bind variables. Use the ALTER SESSION statement to enable FORCE:
1* alter session set cursor_sharing=force
SQL> /
Session altered.
CURSOR_SHARING=SIMILAR will auto-bind only when the difference will not cause a drastic change to the plan.
Notes continue on the next page…