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.

Wow


In the following Discussion (http://scn.sap.com/thread/3713659) 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?

Really?

...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?

Regards,

Michael

Tags:

Helpful Answer

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