Resident portion of shared memory
The operating system, as it switches between the processes that run on the system, normally swaps the contents of portions of memory to disk. When a portion of memory is designated as resident, however, it is not swapped to disk. Keeping frequently accessed data resident in memory improves performance because it reduces the number of disk I/O operations that would otherwise be required to access that data.
- The operating system supports shared-memory residency.
- The RESIDENT parameter in the onconfig file is set to -1 or a value that is greater than 0.
The resident portion of the database server shared memory stores the following data structures that do not change in size while the database server is running:
- Shared-memory header
- Buffer pool
- Logical-log buffer
- Physical-log buffer
- Lock table