0 Replies Latest reply on Sep 27, 2013 1:24 AM by rm0han

    PreparedStatementCache

    rm0han

      Hi,

                Is there a way to quantify the number of elements to be configured in this cache based on actual production data ? Should I turn on a JVM switch or analyze Oracle StatsPack ? It would be helpful if it is a JMX monitor or a -D switch. WebLogic has -DJDBCSQL switch.

       

      We want to quantify the heap bloat caused by this ? What is going to hold on to these cache elements ? Is there an impact on GC ?

       

      Thanks.