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)
102400 - 2147483648
takes effect
After you edit your onconfig file and restart the database server.


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.

Copyright© 2018 HCL Technologies Limited