Re: Question about mlock_sga

You say it is rare that unix processes would page out the Oracle SGA. Do you know of any situations that may cause this? Do you know of any literature documenting this (I can't find anything in the manuals). Thanks.

On 7 Jun 1999 23:10:26 GMT, rniemic_at_aol.com (Rniemic) wrote:

>This means that the SGA will not be paged out by other UNIX processes needed
>memory. The data,PL/SQL...etc. will still be moved out of the SGA as it
>becomes the least recently used (LRU). This parameter is to ensure that other
>UNIX stuff doesn't page out your Oracle SGA (which is rare). Also note that
>you can pin PL/SQL and cache tables making them the Most Recently Used.
>
>Hope that helps,
>Rich Niemiec
>Oracle Performance Tips and Techniques
>Oracle Press
>ISBN: 0078824346
>
Received on Wed Jun 09 1999 - 14:22:22 CDT