Re: How to cope with Oracle's bad mood

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Thu, 11 Dec 2003 01:48:35 +0100
Message-ID: <cifftvkvl4thtdgo7tcr8c35gfhehd675j@4ax.com>

xux_at_informa.bio.caltech.edu (Xuequn Xu) wrote:

>Setting cursor_sharing=force could be the exact cause of this.
>Try turning it back to "exact" in a session (i.e. "alter session ...")
>and see if the query works again, in that session. If it does,
>this would be a good case in point that developers should always
>use bind variables and DBAs should NOT always call for
>cusrosr_sharing=force to the rescue.

You were completely right, setting cursor_sharing to exact at session level solved the problem.

But it will keep the valeu "force" at instance level because the performance gain is giant.

Thanks
Rick Denoire Received on Wed Dec 10 2003 - 18:48:35 CST