Maintain a targeted amount of memory in embedded applications

You can configure the database server to continue processing when memory is critically low, instead of returning an out of memory error.

You specify the criteria for terminating sessions based on idle time, memory usage, and other factors so that the targeted application can continue to process. Configuring the low memory response is useful for embedded applications that have memory limitations.

To configure a targeted amount of memory in embedded applications:
  • Set the LOW_MEMORY_MGR configuration parameter to 1, which enables the automatic low memory management when the 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.

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