Re: comparing tkprof results between cursor_sharing = exact or similar

On Sun, 04 Mar 2007 19:34:18 -0800, Charles Hooper wrote:

> You might want to try CURSOR_SHARING=FORCE, fix the application, add
> hints to the SQL statment so that Oracle does not need to spend as much
> time resolving execution plans, or see if the complex view can be
> simplified.

The setting of CURSOR_SHARING to "FORCE" will cause optimizer to start peeking into bind variables frantically, sometimes with the interesting results. In other words, it introduces uncertainty principle to your database and, in conjunction with histograms, can lead to really interesting plans. God may play with dice, but I don't like to do so. When Turing created the world some time ago, he created constants and there are variables. That was an intelligent design. Blurring the difference between them is not a good idea from the philosophical point of view.

-- 
http://www.mladen-gogala.com