SAP Knowledge Base Article - Preview

3571947 - The reason for a statement invalidation / recompilation

Symptom

The runtime of a query is longer than expected and the query is recompiled.

The reason for a statement invalidation / recompilation can be determined via column LAST_INVALIDATION_REASON of monitoring view M_SQL_PLAN_CACHE and M_SQL_PLAN_STATISTICS (for details about already evicted SQL cache entries). You can use SQL: "HANA_SQL_SQLCache".


Read more...

Environment

  • Starting with SAP HANA 1.00.122.17 and 2.00.020

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

"recompilations", "LAST_INVALIDATION_REASON", "2124112" , KBA , HAN-DB-PERF , SAP HANA Database Performance , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.