6 Replies Latest reply on Jul 6, 2015 9:51 AM by Yanick Girouard

    How to properly scope maximum database connections settings?

    Yanick Girouard

      In BSA using Oracle, we're starting to run out of database connections when certain jobs run, and/or when the ETL runs. This error is thrown when this happens: ORA-12516, TNS:listener could not find available handler with matching protocol stack


      According to our DBA, we have reached the 400 connections limit of the DB server and would need to increase it in order to resolve the issue. Since doing this requires a restart of the application (thus, downtime), and that we will most likely need to increase the amount of memory of the database server to support those extra connections, we would like to set it to a proper number the first time around to avoid having to create another downtime later if it's insufficient.


      There are also connection settings in BSA that could be changed to help control that:


      set database MaxGeneralConnections #

      set database MinGeneralConnections #


      However, there again, it's hard to know how much we'll need. Both those settings ate currently set to 100.


      Is there a formula or something I could use to properly scope the required number of connections that we'd need to set both on the Oracle server and in BSA?