Re: Pinning Packages

From: Phil Herring <revdoc_at_uow.edu.au>
Date: 1998/03/12
Message-ID: <6e9skb$ehr$1@wyrm.its.uow.edu.au>#1/1

In article <2BA8880B268CD1118E4600609720EB18A479A2_at_mail.dsams.com> Joe Babaloo, jsuriol_at_dsams.com writes:
>What does Oracle do to memory when it pins packages. Are the memory
>pages in which
>packages reside locked so they cannot be swapped out? What system calls
>does oracle use pin
>those packages?

Pinned packages simply don't get aged out of the shared pool; this doesn't affect any paging that may or may not occur with the SGA as a whole. Paging can only be controlled by the use of system-specific init.ora parameters; for example, under Solaris, use_ism=true will enable the use of intimate shared memory for the SGA where it's available (Ultra SPARC systems don't support ISM), otherwise it has no effect. Some other OSs have their own variant of use_ism, but not all OSs provide mechanisms for locking shared memory segments.

---

Copyright 1998 Phil Herring. This article may not be reproduced for profit.

---

Received on Thu Mar 12 1998 - 00:00:00 CST