Adaptive Server allocates physical memory dynamically. This allows users to change the memory configuration of Adaptive Server without restarting the server.
Adaptive Server allocates memory dynamically; however, it does not decrease memory dynamically. It is important that you accurately assess the needs of your system, because you may need to restart the server if you decrease the memory configuration parameters and want to release previously used physical memory. See “Dynamically decreasing memory configuration parameters” for more information.
Consider changing the value of the max_memory configuration parameter:
When you change the amount of RAM on your machine
When the pattern of use of your machine changes
When the configuration fails because max_memory is insufficient.