Re: Growth of CCursor sub-heap of the shared pool

From: John Hurley <johnthehurley_at_gmail.com>
Date: Fri, 13 Dec 2013 16:45:13 -0800 (PST)
Message-ID: <343c9d48-f4e2-46d4-99e7-084845a48ea7_at_googlegroups.com>


First question is do you really need 4 subpools? Can be configured to "not do that" via the old undocumented parameter approach but are you hitting latch problems on shared pool?

Flushing the shared pool should work ... some people ( old school ) recommend several flushes in succession. Gighting it out via oracle support is recommended if one cannot afford to bring in a high profile outside resource ( expensive ).

Memory leaks in oracle code are always possible. Received on Sat Dec 14 2013 - 01:45:13 CET

Original text of this message