1 Reply Latest reply on Apr 7, 2016 7:49 PM by Kris Rice-Oracle

    Too many requests.

    Test2

      Hello,

      I am using ORDS 3.0.3 on Oracle 11.2.3 SOE. APEX 5.3.

       

      I am using RESTful POST to track visits to websites hosted on other servers. - An alternative to Google Analytics.

       

      In this case, there are too many requests coming.

       

      What is the best parameters configuration for that ?

       

      From what I got from   Kris blog ,

      MaxLimit: determines the largest number of allowed active connections.

      MaxConnectionReuseCount: determines the number of request each connection handles.

      InactivityTimeout: number of seconds to close an idle connection.


      So, since there are too many requests to my server, I have the below configuration:

       

      <entry key="jdbc.DriverType">thin</entry>

      <entry key="jdbc.InactivityTimeout">300</entry>

      <entry key="jdbc.InitialLimit">3</entry>

      <entry key="jdbc.MaxConnectionReuseCount">10000</entry>

      <entry key="jdbc.MaxLimit">6000</entry>

      <entry key="jdbc.MaxStatementsLimit">50</entry>

      <entry key="jdbc.MinLimit">20</entry>

       

      However, I am still getting errors like all connections are used, Java Pool already established, cannot establish another pool...