SQL Plan Cache Size
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 (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?
...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?