Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle internal memory management
M.Rapier wrote:
>
> It is a _very_good_idea_ to pin large packages you use on a regular basis
> using the dbms_shared_pool package. This ensures they are kept in memory
> (which is where they need to be anyway) - set up a job to pin them daily at
> least, especially things like DBMS_STANDARD which is referenced all over the
> place. The x$ksmlru table is also useful for keeping track of the allocation
> of objects in the shared pool. You also need to get rid of big anonymous
> blocks, use bind variables etc.
>
You need to constently re-pin your PL/SQL packages. I only pinned them once (when the package is created and I have not had the shared memory problem return. Do I need to pin them on a daily basis to avoid this problem?
Eric Mortensen Received on Thu Nov 07 1996 - 00:00:00 CST