Symptom
- SQL query consumes all memory up to the GLOBAL_ALLOCATION_LIMIT and/or PROCESS_ALLOCATION_LIMIT, exceeding the value configured for statement_memory_limit parameter.
- Memory Tracking is enabled as described the question 11. Is it possible to monitor the memory consumption of SQL statements? from the KBA 1999997 - FAQ: SAP HANA Memory.
Read more...
Environment
- SAP HANA, platform edition
Product
SAP HANA, platform edition all versions
Keywords
SAP HANA, statement_memory_limit, SQL query, memory consumption, OOM dump, Column Table unload, ZSE16N, COEP table, database performance, parameter configuration, memory pressure, global.ini, host layer, composite OOM dump. , 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.
SAP Knowledge Base Article - Preview