Configure the server response when memory is critically low

You can configure the actions that primary or standard database server takes when memory is critically low. You can specify the criteria for terminating sessions based on idle time, memory usage, and other factors so that the targeted application can continue to process. Low-memory responses are useful for embedded applications that have memory limitations.

To set up automatic low-memory management on a primary or standard server:
  • Set the LOW_MEMORY_MGR configuration parameter to 1, which enables low-memory management when the database server starts.
  • Set the threshold parameters for the amount of memory to maintain by using an SQL administration API command with the scheduler lmm enable argument.
  • Verify that the SHMTOTAL configuration parameter is set to a positive integer value.

To disable automatic low-memory management, run an SQL administration API command with the scheduler lmm disable argument.