SAP Knowledge Base Article - Preview

3654559 - statement_memory_limit parameter not respected during SQL query execution in SAP HANA

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.