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