You want to know the recommended value for statement_memory_limit which defines the maximum memory allocation per statement in GB. The default value is 0 (no 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.
- HANA 1.0 SPS8 or newer
- HANA 2.0
statement_memory_limit; GENERIC_COMPOSITE_LIMIT; , KBA , HAN-DB-PERF , SAP HANA Database Performance , Problem
About this pageThis 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.