SAP HANA Forum
May I know that why do I get an OOM although the SAP HANA allocation limits aren't reached?
Kindly share your views, Thanks in advance.
The following reasons can be responsible for OOM situations although neither the global nor the process specific allocation limits aren't reached:
Operating system memory exhausted
Check if the available memory is exhausted on operating system side, e.g. because of external software allocating a lot of memory, large caches or another SAP HANA instance. Make sure that in the future there is always enough physical memory available to host the complete SAP HANA allocation limit.
Small temporary process allocation limit
Based on the defined allocation limits SAP HANA and the current service memory allocations the temporary process allocation limit (TPAL) may be significantly smaller than the defined allocation limit. As a consequence OOMs are possible although the configured allocation limits aren't reached. SAP 2133638 describes a related startup issue that can happen as of Rev. 90.
Statement memory limit reached
OOM dumps with "compositelimit" in their names are no global memory shortages. Instead they are linked to a defined statement memory limit. See "Is it possible to limit the memory that can be allocated by a single SQL statement?" above for more details.
Sign up for STechies
Ask Question From Our Experts