Kbase 38856: What effect does Pin Shared Memory ( -pinshm startup option ) have on the database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/12/2002 |
|
Solution ID: P8856
GOAL:
What effect does Pin Shared Memory ( -pinshm startup option ) have on the database?
FIX:
According to the "Startup Command and Parameter Reference," issuing the -pinshm on database startup "prevents the database engine from swapping shared memory contents to disk."
Pinning the segments guarantees that the segments are always in memory. They are never swapped to disk. This prevents performance degradation of the database issuing the -pinshm.
The effect on the entire system, however, is that there will be less memory available for other things. If the system has multiple database using the -pinshm parameter, several of which are seldom used, the overall system maybe negatively impacted.