Register Login

Get an OOM although the SAP HANA allocation limits aren't reached?

Updated May 18, 2018

Hello Experts,

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.


Comments

  • 16 Mar 2016 3:55 pm Abhijeet Mudgal Best Answer

    The following reasons can be responsible for OOM situations although neither the global nor the process specific allocation limits aren't reached:

    Reason:

    Operating system memory exhausted

    Details:

    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.

    Reason:

    Small temporary process allocation limit

    Details:

    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.

    Reason:

    Statement memory limit reached

    Details:    

    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.


×