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

On May 2, 4:08 pm, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -

That's okay. I've seen some notes on Metalink, and on other forums.

Thanks again. Received on Wed May 02 2007 - 18:13:28 CDT