Re: Cursor sharing on Win32 - 'the safe bet?'

On May 2, 5:02 pm, BD <robert.d..._at_gmail.com> wrote:
> On May 2, 1:44 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> > Be careful with setting CURSOR_SHARING to FORCE on Oracle 10.2.0.2. I
> > had run Oracle 8.1.7.3 for years with CURSOR_SHARING set to FORCE
> > without issue, and made it several months on 10.2.0.2 with the
> > parameter set the same way. Then, I applied the October 2006
> > patchset, and only made it through one day of production use before
> > sessions started dropping with ORA-07445 errors - this is on Windows
> > 2003 x64, but others on Metalink have indicated similar problems on
> > Linux, Unix, and other platforms as well.
>
> > Charles Hooper
> > IT Manager/Oracle DBA
> > K&M Machine-Fabricating, Inc.
>
> Another DBA attempted to set it to SIMILAR, and *INSTANTLY* started
> getting 07445 errors.
>
> I wonder if we should open a TAR on this?

I did not get anywhere with a TAR on this problem last November. I have been following Metalink bug logs since that time - it appears that a fix will be released in a month or two for both 10.2.0.2 and 10.2.0.3 - I do not have the Metalink bug number at hand where this was mentioned.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Wed May 02 2007 - 18:08:16 CDT