Re: Anybody hitting Bug 5648872 Dump (opidsa) from DESCRIBE of a cursor (10.2.0.3)

  • From: "Andre van Winssen" <dreveewee@xxxxxxxxx>
  • To: mgs@xxxxxxxx
  • Date: Wed, 28 Mar 2007 11:07:45 +0200

Unfortunately we need the patch for windows which is due in 10203 patch 5.
so we need to do shared_pool flushing for another couple of months ourselves
(or ask DBMS_JOB to do it on our behalf)

imagine one'd have to flush the toilet every so often to prevent the house
from falling apart
makes no sense

Andre


2007/3/28, Michael Garfield Sørensen, CeDeT <mgs@xxxxxxxx>:

Hi Andre,

There seems to be a patch (Patch 5648872) available for 10.2.0.3 on
several platforms - see Note 418531.1.

HTH
Michael

Quoting Andre van Winssen <dreveewee@xxxxxxxxx>:

> Hello,
>
> just found out about a problem (Bug 5648872  Dump (opidsa) from DESCRIBE
of
> a cursor) that started in 10.2.0.3 and is still not fixed. It can lead
to
> client sessions crashing with ORA-7445 errors. It is said to be fixed in
11g
> according to note *Note:5648872.8. *"Flushing the shared pool can clear
the
> problem for a period of time" the note says..
>
> The random nature of this issue doesn't make the latest and greatest
10gR2
> version look like robust enough to entrust 24*7 applications to it.
>
> Have more people run into this and how often?
>
>
> Regards,
> Andre



--
//www.freelists.org/webpage/oracle-l



Other related posts: