Re: ORA-4031/Shared Pool

From: Roger Snowden <rsnowden_at_labinterlink.com>
Date: 1997/01/08
Message-ID: <01bbfd82$e1ae6860$096fc589@LHV-06.labinterlink.com>#1/1

David Kaiser <davidk_at_sfmic.com> wrote in article <32CC2F16.4950_at_sfmic.com>...
> We have been wrestling with this error for a while. I fully understand
> why we get this error (usually when trying to run larger packages).
>

The Keep() function is part of the answer. You don't have to run it every time the instance starts up, but you might want to execute the procedure right away. The Keep function simply flags it in the shared pool to not age out, but it has to be there before the fragging begins. So, execute it once and it should stay pinned until you run the unkeep() function.

Oracle 7.3 handles fragged library cache much better. It allows procedures to reside in non-contiguous chunks of memory, so is more frag-tolerant. Until then, keep() the big, critical stuff, and expand the shared pool if you can.

Roger Received on Wed Jan 08 1997 - 00:00:00 CST