SAP Knowledge Base Article - Preview

3296543 - Inexpensive queries fail with composite OOM on SAP HANA DB

Symptom

Queries get terminated with an out of memory error, for example: 4: cannot allocate enough memory

This can also generate a composite out of memory dump <service>_<host>.<port>.rtedump.<timestamp>.compositelimit_oom.trc

When checking the statistics (e.g. OOM trace or M_OUT_OF_MEMORY_EVENTS), you can see that the query actually allocated less than the defined statement allocation limit.


Read more...

Environment

  • SAP HANA 2.0 SPS04: >= 2.00.048.03
  • SAP HANA 2.0 SPS05: >= 2.00.052

Product

SAP HANA, platform edition 2.0

Keywords

statement_memory_limit, global.ini, [memorymanager], impli_enable_reset, M_CONTEXT_MEMORY, allocation limit, M_OUT_OF_MEMORY_EVENTS  , KBA , HAN-DB , SAP HANA Database , 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.