963512 wrote:These ratios are barely worth looking at - to a large extent they're a waste of time, but in most cases they cause confusion rather than helping. (See http://jonathanlewis.wordpress.com/2006/12/27/analysing-statspack-2/ )
But, this has not bumped up the 'Execute to Parse%' to an expected value of ~100%, but only 45%. Now, would there be a recommended value or the criteria to calculate "*what is the best value for the oracle.jdbc.implicitStatementCacheSize to be set to get the optimum value in the execute to parse% ?*"
Any best advise is higly appreciated!!
The SQL queries have already been tuned. Please provide any other info related to utilizing the DB capabilities in the optimum way, such as improvising and best utilizing Caching (esp. statement caching)It is multiple times asked here - do SQLs use bind variables or literal values?