Home » RDBMS Server » Performance Tuning » Can I lock SGA in RAM
Can I lock SGA in RAM [message #65563] Fri, 29 October 2004 02:40 Go to next message
Messages: 105
Registered: February 2004
Senior Member
Hi, Frends

I have read in some where on net that we can lock the SGA in RAM.. is it really true ? if yes then how can we lock the sga in RAM? and what is a advantage of Locking a SGA IN RAM??

Thax in advance....

Re: Can I lock SGA in RAM [message #65564 is a reply to message #65563] Fri, 29 October 2004 04:06 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
lock_sga is the initparameter used.
It is OS dependent.

Have a look here

quoting the above doc

1) MLOCK_SGA/LOCK_SGA/_LOCK_SGA etc. are all parameters that facilitate locking
of the SGA in memory and preventing it from being paged/swapped. Proper use of this
parameter will prevent the paging algorithm from considering the memory pages used by the
SGA for page-outs.
This provides a significant performance benefit especially during periods of
heavy activity. This parameter should not be used if the system is not configured with an
optimal amount of memory to begin with.
</end quote>

then what is the use of paging and swapping??
Previous Topic: Cycling alert log
Next Topic: oracle database file corruption!
Goto Forum:

Current Time: Wed Jan 27 12:07:30 CST 2021