Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle internal memory management
In article <32823CB3.1BBC_at_cibadiag.com>, mortense_at_cibadiag.com says...
>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
{snip}
>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?
Well we are in the luxurious position of being able to shut down the database each night for backups, but of course it gets restarted without anything being pinned.
It would be more accurate to say that the packages need repinning on database startup, so it is probably a suitable extra clause to add to 'dbstart' or whatever you use to start your system.
The ones that Oracle recommend you pin are STANDARD, DBMS_STANDARD and the wierd and wonderful DIUTIL, plus any other standard ones or local you use regularly.
Cheers.
Martin.
Received on Fri Nov 08 1996 - 00:00:00 CST