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

On May 2, 7: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.

Previously researched bug reports on Metalink that are related to this topic:

Note:418531.1, published 20-MAR-2007, Dump in opidsa() after Applying the 10.2.0.3 Patch Set, patch is expected to be available with 10.2.0.3 Patch 5. After having applied the 10.2.0.3 patch set, processes from user sessions can core dump (ORA-7445) in opidsa(). It is also known to affect Windows 10.2.0.2 Patch 6 upwards.

Note:418855.1, published 12-MAR-2007, ORA-7445[opidsa] from client connections

Bug No 5910780, Filed 01-MAR-2007, Updated 07-MAR-2007, ORA-07445 [OPIDSA] on 10.2.0.3 SPARC 64 bit)

Bug 5901676, Filed 25-FEB-2007, Updated 26-FEB-2007, APPLICATION CRASHING WITH ORA-07445 [OPIDSA()+480] on SPARC 64 bit

5871184 Affects 10.2.0.3 on Windows 2003 64 bit

5869965 Affects 10.2.0.3 on Linux

5856953 Affects 10.2.0.3 on Windows 2003 32 bit Standard Edition

5766301 Affects 10.2.0.2 on AIX5L Based Systems (64-bit) after applying patch 10 - Now labeled as platform generic, only affecting Windows x64 - Now no longer references Windows x64, nor the largest bank in Norway.

5708361, tar 5994983.993 Affects 10.2.0.2 on Windows 2003

5745817, tar 6031196.994 Affects 10.2.0.3 on Windows 2003

5752147 Affects 10.2.0.3 on Red Hat Enterprise Linux - may contains some useful information

5761998 Affects 10.2.0.2 on Windows XP 64 bit

5741417, Affects 10.2.0.3 on Windows 2000

5680308, Affects 10.2.0.2 on Windows 2003

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Thu May 03 2007 - 12:32:36 CDT