Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-04031 Errors - Unsharable SQL
I did look at that bug on MetaLink. The error message caused by that
bug is the same as I am seeing, but the underlying symptoms are
different. The bug causes permanent memory to grow while free memory
decreases, in my case permanent memory is stagnant. Only the sql_area
memory usage grows. I am able to reclaim free memory by flushing the
shared pool, which would not work in the case of the bug (I have
automated that by the way, never was doing it manually;). Also, my
first action after experiencing the problem and viewing MetaLink, was
to set the _db_handles_cached=0 parameter. It did not fix the
problem.
Based on everyone's response, all I can do for now is what I have been doing and to push the developers to fix their code. I could threaten to put them on the 'Shoot the developers' list..........
Thanks for everyone's feedback. It is much appreciated.
later ......
Berno Strik <BStrik_at_office.casema.nl> wrote in message news:<3BC3E93C.4C2E0C1F_at_office.casema.nl>...
> Hello Patrick,
>
> You should also look on metalink at bug 1649372. It describes the same symptoms.
> It can be fixed by setting the undocumented parameter: _db_handles_cached=0.
>
> HTH Berno
Received on Wed Oct 10 2001 - 11:57:54 CDT