The toilet is another shared pool that should be flushed often.... Much
worse than 4031 errors if you don't.
On 3/28/07, Andre van Winssen <dreveewee_at_gmail.com> wrote:
>
> 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_at_cedet.dk>:
> >
> > 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_at_gmail.com>:
> >
> > > 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
> >
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 28 2007 - 09:44:30 CDT
