SAP Knowledge Base Article - Preview

3228858 - High usage of memory by Pool/Statistics because of JDBC client


  • You are using system which connects to SAP HANA database using SAP HANA JDBC client e.g.
    • SAP Solution Manager
    • SAP Manufacturing Execution System (MES)
    • etc.
  • You experience high memory usage in allocator (SQL Statement: "HANA_Memory_Overview") e.g.
    • Pool/RowEngine/QueryExecution/SearchAlloc
    • Pool/Statistics
  • You experience very high number e.g. 100.000 or even 1.000.000 "M1152 Max. SQL contexts per connection" and it increases over time (SQL Statement: "HANA_Configuration_MiniChecks")
    The following example shows 3 days of increased contexts per connection:
    M1152Max. SQL contexts per connection226035<= 5000X2000002
    M1152Max. SQL contexts per connection418163<= 5000X2000002
    M1152Max. SQL contexts per connection627449<= 5000X2000002
  • You have also all the other symptom which are listed in SAP Note 2711824
  • You can experience SAP HANA Alert 43 - Memory usage of services
  • Used memory never be released by itself. To solve the issue and release the memory you need to restart the database or you need to cancel the connections manually.



SAP HANA, platform edition 2.0


SAP HANA, platform edition 2.0


OOM, out of memory, M1152, Pool/Statistics, Pool/RowEngine/QueryExecution/SearchAlloc, high memory, transactionalLobs=false, connection string, JDBC, client , KBA , HAN-DB-ENG , SAP HANA DB Engines , Bug Filed

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.