SAP Knowledge Base Article - Preview

3522930 - Statement Memory Limit configuration scope

Symptom

In SAP KBA 2600030 - Parameter Recommendations in SAP HANA Environments, there is recommendation configuration for parameter statement_memory_limit:
MIN(10 % of allocation limit, 30 GB) - MIN(30 % of allocation limit, 500 GB) 

It is meaning, the minimum value of this parameter can be set between smaller value in GLOBAL_ALLOCATION_LIMIT*10% and  30GB. 
The maximum value of this parameter is the smaller value in GLOBAL_ALLOCATION_LIMIT*30% and 500GB.

For example, you have 100 GB GLOBAL_ALLOCATION_LIMIT, then you can set min(100*10%, 30GB) to min(100*30%, 500GB), that is min(10GB, 30GB) to min(30GB, 500GB). So the detail is 10~30GB is recommended scope.

Setting this value to "-1" will calculate the statement_memory_limit as 25% of the smaller of global_allocation_limit and process_allocation_limit. By default this value is not set which means no restriction, and single SQL can use memory up to GLOBAL_ALLOCATION_LIMIT, however if it requested up to GLOBAL_ALLOCATION_LIMIT, instead of composite OOM, there will be system layer OOM happening.


Read more...

Environment

SAP HANA database

Product

SAP S/4HANA 2022

Keywords

KBA , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.