SAP HANA -Out of Memory Occurs due to High Usage of Shared Memory

Shared memory is space where system information and row store tables are stored.
Check the following if the used amount of shared memory is high.

Required action:

1.Check whether SHARED_MEMORY in [MEMORY_OOM] -> IPMM short info of OOM dump is relatively high

2.Apply SAP Note 1813245 – SAP HANA DB: Row store reorganization

Root cause: Due to memory shortage caused by high used memory of row store tables in an SAP Business Warehouse (BW) system

Required action: In an SAP Business Warehouse system the used amount of shared memory is high and SAP Note 1813245 doesn’t recommend row store reorganization, first apply SAP Note 706478 – Preventing Basis tables from increasing considerably, then apply SAP Note 1813245 – SAP HANA DB: Row store reorganization again

 

Root cause: Due to memory shortages caused by high used memory of row store tables in non SAP Business Warehouse (BW) systems

Required action: Check if you can convert some row store tables into column store tables or archive old data to reduce the memory size, or else increase the system memory.

Reference:http://help.sap.com/hana/SAP_HANA_Troubleshooting_and_Performance_Analysis_Guide_en.pdf

Leave a Reply