Skip to Content
0

Out of Memory Dumps in SAP HANA

Oct 16, 2017 at 04:17 PM

50

avatar image

Hello Experts,

Recently we encountered few out of memory dumps in SAP HANA. The dumps occurred certainly due to expensive BW queries or statements.

From OOM we are able to trace the Statement String, Statement hash and PLAN ID, however we are having tough time finding the actual statement or query which has resulted this OOM dump.
Statement String is like call "jobscheduler::SCHEDULER_CHECK_IN" (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

We would like to know who calls or how to we trace the actual statement/query which caused the situation.

Thanks.

10 |10000 characters needed characters left characters exceeded

Hello Experts,

Expecting suggestion on the above queries especially by BW on HANA administrator.

Thanks in advance.

0

Also can someone explain the how can we use below view to identify if the statement is expensive.

M_SQL_PLAN_CACHE System View

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers