SESSION_LIMIT_MEMORY configuration parameter

The SESSION_LIMIT_MEMORY configuration parameter specifies the maximum amount of memory that a session can allocate. This limit does not apply to a user who holds administrative privileges, such as user informix or a DBSA user.

onconfig.std value
0 (off)
if not present
0 (off)
values
20480 - 2147483648
units
KB
takes effect
After you edit your onconfig file and restart the database server.

Usage

The SESSION_LIMIT_MEMORY configuration parameter limits how much memory a session can allocate, and can prevent individual sessions from monopolizing system resources.

The database server terminates a session that exceeds the memory limit, puts a message in the database server message log, and triggers the event alarm 21016.

The session_limit_memory tenant database property set through the tenant create or tenant update SQL API command takes precedent over the SESSION_LIMIT_MEMORY configuration parameter setting.


Copyright© 2019 HCL Technologies Limited