Re: ORA-4031 and Shared Pool Fragmentation

From: Alan Molloy <alan_molloy_at_hotmail.com>
Date: Tue, 07 Nov 2000 19:25:41 GMT
Message-ID: <01c048ef$9fa1f970$617da8c0@opc097>

Great,
Thanks for that. I'll get an 8.1.6 upgrade. Prior to upgrading to 8.1.6, am I stuck with a situation that I'll get 4031 errors as long as I keep running applications that generate this SQL differing in literals? And will I continue to get shared pool and library cache latch contention?
Regards,
Alan.

jdarrah_co_at_my-deja.com wrote in article <8u9h45$qqr$1_at_nnrp1.deja.com>...
> The words keep and default refer to block buffer pools, not the shared
> pool. Upgrading to 8.1.6 would allow you to set cursor_sharing=force.
> Any sql that is differing only in literals would automagically have
> bind variables substituted in. If the sql is truely dynamic, this
> won't help but if its just that a third party application uses literals
> instead of binds, it could. There is a script that will automatically
> pin packages that are in the shared pool it can be downloaded off of
> http://www.evergreen-database.com.
>
Received on Tue Nov 07 2000 - 13:25:41 CST