2 Replies Latest reply on Nov 20, 2019 7:17 AM by Martien van den Akker

    Maximum Connection pool allowed in Weblogic 12.2.1.3

    aspardhya

      Is there any limitation of connection pool for Weblogic 12.2.1.3 version?

        • 1. Re: Maximum Connection pool allowed in Weblogic 12.2.1.3
          Srinath Menon-Oracle

          Theoretically , No, there is no such limitation but practically it should be defined based on the application load and kind of work it is going to process.

          • 2. Re: Maximum Connection pool allowed in Weblogic 12.2.1.3
            Martien van den Akker

            As Srinath mentioned, there is no theoretical maximum in Weblogic.

            But consider that a connection pool causes every managed server that the datasource is targetted to, to create database connections. This means that if the datasources' connection pool can have 3000 connections and it is targetted to a cluster of two managed servers, the database can get possibly 6000 connections. A datasource has also a statement cache. By default of 10. This means that the database needs an OPEN_CURSORS parameter value of 2x3000x10 = 60000. Assuming that you have an Oracle database.

             

            This means that for Weblogic there isn't a maximum, but increasing this value means that there should be enough resources in the database. So there is an actual resource limit. Discuss with your DBA to determine what they can provide.

             

            Kind regards,
            Martien

            1 person found this helpful