| Can I lock SGA in RAM [message #65563] |
Fri, 29 October 2004 02:40  |
BhavinShah
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....
Bhavin
|
|
|
|
| Re: Can I lock SGA in RAM [message #65564 is a reply to message #65563] |
Fri, 29 October 2004 04:06  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
lock_sga is the initparameter used.
It is OS dependent.
Have a look here
http://www.quest.com/whitepapers/orcl_db_mgmt.pdf
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??
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
