Memory Manager

Use this page to view information about server memory usage and to enable automatic low memory management. Configure the actions that the database server takes to continue processing when memory is critically low.

Database Server Memory Overview

Information about the sessions connected to the database server, including the number of sessions, the size of the largest session, and the average session size.

Memory Usage

The amount of database server memory and operating system (OS) memory. Move the cursor over the graphic to display the amount of used, free, and total memory.

Low Memory Manager

The settings for automatic low memory management, which specify the criteria for terminating sessions so that the targeted application can continue and avoid out-of-memory problems. Configuring the low memory response is useful for embedded applications that have memory limitations.

When low memory management is triggered, the database server performs these tasks, in order:

1. Terminate sessions starting with the session with largest amount of idle time and continuing to the session with smallest amount of idle time that exceeds the idle session threshold. The database server stops terminating sessions when the idle session threshold is reached.
2. Terminate sessions starting with the session using the most memory and continuing to the session using the smallest amount of memory until the stop threshold is reached.
3. Reconfigure memory by setting the VP_MEMORY_CACHE configuration parameter to 0 and running the onmode -F command to free unused shared memory segments. When the low memory management operations are complete, the configuration parameter is restored to its original value.

Start threshold

Specify the amount of free memory that you want the database server to maintain. When the amount of free memory decreases to less than this threshold, the Low Memory Manager starts terminating applications and freeing memory.

Stop threshold

Specify the amount of free memory that you want the database server to have before the database server stops terminating applications and freeing memory.

Idle session threshold

Specify the amount of time in seconds that defines a session as idle. When a session is idle longer than this amount of time, the session is considered idle.

Sessions terminated

The total number of sessions that were terminated by the database server.

Last termination

The time that the last session was terminated by the database server.

Last reduction

The last time that the database server reconfigured memory and freed unused shared memory segments.

Last restoration

The last time that the database server restored the memory configuration of the server.