Managing Shared Memory

Managing shared memory includes the following tasks:

• Changing the size or number of buffers (by changing the size of the logical-log or physical-log buffer, or changing the number of buffers in the shared-memory buffer pool)
• Changing shared-memory parameter values, if necessary
• Changing forced residency (on or off, temporarily or for this session)
• Tuning checkpoint intervals
• Adding segments to the virtual portion of shared memory
• Using the SQL statement cache to reduce memory usage and preparation time for queries

For information on how the database server uses shared memory, see Shared Memory. For additional information, see Shared-Memory Parameters and Managing Shared Memory.