SAP Knowledge Base Article - Preview

3441226 - Recommended value for parameter statement_memory_limit

Symptom

You are looking for recommended value of statement_memory_limit which defines the maximum memory allocation per statement in GB.
The default value is 0 (no limit) up to SAP HANA 2.0 SPS05.
The default value is -1 from SAP HANA 2.0 SPS06, that means 25% of global_allocation_limit or process_allocation_limit.

  • In the global.ini file, expand the memorymanager section and locate the parameter. Set an integer value in GB between 0 (no limit) and the value of the global allocation limit. Values that are too small can block the system from performing critical tasks.

  • When the statement memory limit is reached, a dump file is created with 'compositelimit_oom' in the name. The statement is aborted, but otherwise the system is not affected. By default only one dump file is written every 24 hours. If a second limit hits in that interval, no dump file is written. The interval can be configured in the memorymanager section of the global.ini file using the oom_dump_time_delta parameter, which sets the minimum time difference (in seconds) between two dumps of the same kind (and the same process).

  • The value defined for this parameter can be overridden by the corresponding workload class property STATEMENT_MEMORY_LIMIT.

After setting this parameter, statements that exceed the limit you have set on a host are stopped by running out of memory.


Read more...

Environment

  • SAP HANA database 1.0 SPS8 or newer
  • SAP HANA database 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

statement_memory_limit; GENERIC_COMPOSITE_LIMIT; , KBA , HAN-DB-PERF , SAP HANA Database Performance , 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.