Re: 8.1.7.3 and the shared pool

From: Scott Gamble <zifnab_at_reddragon.org>
Date: Tue, 18 Jun 2002 18:57:49 GMT
Message-ID: <NoLP8.5620$Bz4.30905@petpeeve.ziplink.net>

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in news:aenuk2$67m$1_at_babylon.agtel.net:

> I wouldn't rely on CURSOR_SHARING as there is a number of bugs known,
> and some caveats to know, with one major that it will rewrite queries
> you normally wouldn't want it to. Also, there is a bug fixed in
> 8.1.7.4, namely 2104071, which may, or may not be relevant to your
> situation. Bug description is as follows:
>
> Bug 2104071 Fixed: 8174
> a.. Resource Leaks (eg: Memory Leak)
> b.. Shared Pool
> c.. XML / XDK
> ORA-4031 / excessive "miscellaneous" shared pool use
> possible due to a single process acquiring a large number of PINS
> on a single library cache object.
> This is known to affect the XML parser.
>
> Although "this is known to affect the XML parser', it may wellaffect
> other areas as well...
>

We have poured through all the 'known' bugs we can see and cannot see one that is relevant. Received on Tue Jun 18 2002 - 13:57:49 CDT