1 Reply Latest reply: Sep 12, 2012 12:04 AM by Prabodh RSS

    What is apex.jdbc.MaxStatementsLimit for ?

    483969
      Hi,

      I'm wondering what exactly is apex.jdbc.MaxStatementsLimit parameter for and if/how the value should be adjusted.

      Documentation says only: Specify the maximum number of statements to cache for each connection. Default = 10

      Thanks,

      Jan
        • 1. Re: What is apex.jdbc.MaxStatementsLimit for ?
          Prabodh
          Hi Jan,
          I'm wondering what exactly is apex.jdbc.MaxStatementsLimit parameter for and if/how the value should be adjusted.
          Documentation says only: Specify the maximum number of statements to cache for each connection. Default = 10>

          These are JDBC parameters detailed here http://docs.oracle.com/cd/B19306_01/java.102/b14355/concache.htm#CDEBCBJC

          You may change the Max numbers to higher values, but do not reduce them. These have a impact on the memory used, and may not necessarily result in improved performance. You may need to find the right set with some trial and error.

          Cheers,