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
>
>
>
