Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question about mlock_sga
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 Mon Jun 07 1999 - 18:10:26 CDT