SAP Knowledge Base Article - Preview

3211034 - Recommended value for parameter statement_memory_limit

Symptom

Memory allocation was failed due to "STATEMENT_MEMORY_LIMIT_FROM_GLOBAL_CONFIG" as following:

Database error number: SQL code: 4
Database error text: "SQL message: cannot allocate enough memory:  [9] Memory
 allocation failed;exception 1000002: Allocation failed ;
$failure_type$=STATEMENT_MEMORY_LIMIT_FROM_GLOBAL_CONFIG; $failure_flag$=;


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