Re: cursor_sharing

Setting cursor_sharing = force has bugs in 8i. Do understand the implications and read about the bugs associated with this (even on 8.1.7.3).

Some places to research:
Search this news group in Google groups: keywords: cursor_sharing bugs Also, look in metalink for the known bugs regarding its usage.

Anurag

"Daud" <daud11_at_hotmail.com> wrote in message news:f0bf3cc3.0208060417.4b6f127e_at_posting.google.com...
> Oracle 8.1.7.3.1
>
> In 8i there is a new parameter (new to me!) cursor_sharing. From the
> doc, setting it to FORCE means forcing oracle to convert all sqls that
> use literal values to use bind variables. This is good especially when
> you have an app that does not use bind variables.
> What's the negative impact of setting it to force? I am a little
> curious because this is not the default setting which one would expect
> it to be if it is really beneficial. Can someone also pls explain what
> extra effort does Oracle need to do when it is set to force and
> whether this extra effort is, in your opinion, worthwhile.
>
> rgds
> Daud
Received on Tue Aug 06 2002 - 08:00:33 CDT