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

    Too many requests.



      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...