[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-4627) Configurable Query Plan Cache

Configurable Query Plan Cache ----------------------------- Key: HHH-4627 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4627 Project: Hibernate Core Issue Type: New Feature Components: query-hql Affects Versions: 3.2.2 Environment: Hibernate 3.22 GA, Oracle 10G database Reporter: Frank Daspro Our application heavily uses dynamic sql some of which are highly parameterised and with many permutations. Out of neccessity we also have a very large JVM heap space (12GB). As a result we end up with a very large memory utilisation for the Query Plan cache. From a recent memory dump it was noted the QueryPlanCache had 25000 entries and consuming 2.5GB of heap space. Our full Garbage collections end up taking longer than it would normally take with a smaller QueryPlanCache. I understand via a related issue (http://opensource.atlassian.com/projects/hibernate/browse/HHH-3191) there is a hard limit of 128 entries, and an endless soft limit which is only garbage collected during a full garbage collection. It would be nice if the following features could be added: 1) Configuration options to specify the hard and soft limits (with a 0 to disable or similar). 2) Configurable at the query level such that specific queries can be excluded from the the QueryPlanCache. eg. something like hibernateQuery.setParsedHQLCacheable(false).