Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL Plan Cache Size

Hello togehter,

arround one week, i have increase the plan_cache_size (indexserver.ini/sql) from default to a custom Value (almost doubled).

Now, one Week later the CACHED_PLAN_SIZE_GB is equal the PLAN_CACHE_CAPACITY_GB.


In the following Discussion ( from last year, Lars Breddemann describes very accurately the Function from the SQL Plan Cache, but i ask me furthermore what happend here.

I'm not really sure, if i should increase the SQL Plan Cache again or not.

If only non-reusable queries take new space, then it make no sense, then i could increase the SQL Plan Cache again and again, increase the threshold so that no alerts are generated or configure the non-reusable queries to take no space?


...but what if there reusable queries take that space?

How do i know this and how can i check, which Statements are getting reparsed?

Which Statements are in the Cache?

What are usable and what are non-usable Statements?

Will improve the Cache the Performance optimization?

Which Statements are getting reparsed and how?




Helpful Answer

Not what you were looking for? View more on this topic or Ask a question