CURSOR_SHARING

CURSOR_SHARING

The default value of parameter Cursor_sharing is Exact. Who changed it?

CURSOR_SHARING is a parameter which decides whether a SQL send from user is a candidate for fresh parsing or will use an existing plan.

CURSOR_SHARING (Default value: Exact): Share the plan only if text of SQL matches exactly with the text of SQL lying in shared pool.

Note: When cursor_sharing =EXACT it uses the index and is 10times faster than cursor_sharing= SIMILAR