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

    What is apex.jdbc.MaxStatementsLimit for ?

    jan.navratil
    jan.navratil Sep 10, 2012 7:36 PM
      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
      • 526 Views
      • Tags:
        • 1. Re: What is apex.jdbc.MaxStatementsLimit for ?
          Prabodh
          Prabodh Sep 12, 2012 5:04 AM (in response to jan.navratil)
          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,