TENANT_LIMIT_MEMORY configuration parameter

The TENANT_LIMIT_MEMORY configuration parameter specifies the maximum amount of shared memory for all sessions that are connected to the tenant database.

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

Usage

When the limit is exceeded, the session that is using the most shared memory is terminated. The value ranges from 100 MB to 2 TB, but must be specified as an integer that represents the number of KB.

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