Oracle Scratchpad

March 9, 2008

Cursor_sharing

Filed under: CBO, Execution plans, Hints, Troubleshooting — Jonathan Lewis @ 9:13 pm UTC Mar 9,2008

From time to time I’ve commented on the fact that setting cursor_sharing to force or similar may be a temporary workaround to bad coding practises, but that it can introduce problems, has a few associated bugs, and shouldn’t  be viewed as a guaranteed, or long-term, solution.

(more…)

Blog at WordPress.com.