HANA MEMORY ERRORS - HOW TO RESOLVE THEM?

ERROR: [MEMORY_OOM]  Information about current out of memory situation

If there is not enough temporary space or physical RAM available, your query will fail.

Check the following: 
The amount of RAM available to the HANA system
The volume of data on which you are operating
The amount of temporary space required by the calculation

SAP RECOMMENDS
SAP recommend you retain 50% of RAM for tables, and 50% for calculation memory

There are several things you can do to reduce, or eliminate, Out of Memory Errors:

1) Upgrade to the latest HANA Revision
2) Migrate the Statistics Server
3) Never use row organized tables
4) Set your tables not to automatically load
5) Partition large tables
6) Redesign your model
7) Make sure your Delta Merges are working correctly
Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved