Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question about mlock_sga

Re: Question about mlock_sga

From: Rniemic <rniemic_at_aol.com>
Date: 7 Jun 1999 23:10:26 GMT
Message-ID: <19990607191026.07273.00001674@ng-fo1.aol.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US