2293665 - Frequently receive alert of "Plan cache size" ( Alert ID 58)

Symptom

You have followed the solution in note 2124112 to handle the HANA Alert 58 - 'Plan Cache Size', but still keep receiving the notification of this alert.

snapshot : 0000-00-00 00:00:00.0000000
Alert Name : Plan cache size
Rating : Error
Details : 703640 plan cache evictions occured on host <hostname>, port <port numebr>.
User Action: Increase the size of the plan cache. In the "sql" section of the indexserver.ini file, increase the value of the "plan_cache_size" parameter.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP HANA Platform 1.0
SAP HANA Platform 2.0

Product

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

Keywords

"SYS"."M_SQL_PLAN_CACHE", PLAN_CACHE_HIT_RATIO, PLAN_CACHE_SIZE, PLAN_CACHE_CAPACITY , KBA , HAN-DB-MON , SAP HANA Monitoring , HAN-DB , SAP HANA Database , How To

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.