6 Replies Latest reply: Jan 30, 2013 5:19 AM by Rajesh Etraju RSS

    AM Pooling Configuration Parameters ??

    Rajesh Etraju
      Hi ,

      I have one application module in my ADF Application. and 30 concurrent users are going to use my application.

      Any one can give me the exact parameters for AM Pooling configuration :

      Pooling and Scalability :-
      ----------------------------------

      Initial Pool size : ??
      Max Pool size : ??
      Referenced Pool Size : ??
      Minimum Available size : ??
      Maximum available size : ??


      Thanks,
      Rajesh.

      Edited by: Rajesh Etraju on Dec 17, 2012 7:13 AM
        • 1. Re: AM Pooling Configuration Parameters ??
          codigoadf
          Hi.
          see the doc about pool parameters http://docs.oracle.com/cd/E15523_01/web.1111/b31974/bcampool.htm#sm0301
          • 2. Re: AM Pooling Configuration Parameters ??
            Rajesh Etraju
            Hi ,

            Thanks for suggestion. I had set the params according to the same . But in my case what i am struggling is....

            Initital PoolSize : 1
            Concurrent Users : 100
            Referenced Pool Size : 3
            Minimum Available Size : 1
            Maximum Available Size: 10
            Idle InstanceTimeOut : 120(sec)
            Pool Pooling Interval : 60(sec)

            Aswell as Enabled the below Options as well :
            1) Reset Non-Transactional State Upon Un Managed Release
            2) Enabled Application Module Connection Pooling
            --I am using the JDBC datasource type in AM.
            --In server data source also we have created with Maxpoolsize 100.
            I am trying to testing with concurrent users for Load Testing like , till 3 concurrent users Its fine. but If i am trying to test with 4 concurrent users, then its giving error like " Application Module not Connected to DataBase" for 4th user.

            What is wrong in the above params for working concurrent users till 30.

            Thanks in advance for your help.

            Rajesh
            • 3. Re: AM Pooling Configuration Parameters ??
              Frédéric Desbiens-Oracle
              Can you check with your DBA how many concurrent connections the database account you are using is entitled to? There is nothing in your settings that prevents 4 concurrent users.
              • 4. Re: AM Pooling Configuration Parameters ??
                codigoadf
                Hi,
                see the doc:
                Initital PoolSize:+A general guideline is to configure this to 10% more than the anticipated number of concurrent application module instances required to service all users.+ .You have 1 but if you have a 30 user you should have 30-33
                also check the Maximum Pool Size and Referenced Pool Size
                • 5. Re: AM Pooling Configuration Parameters ??
                  Rajesh Etraju
                  Not required to check with DBA team.

                  Because if i changed the referenced poolsize to 10 then its allowing till 10 users to login,for 11th user its not allowing to login. So it seems its based on the referenced poolsize. But that should n't be happen right ?

                  If any thoughts !!!

                  --Rajesh                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                  • 6. Re: AM Pooling Configuration Parameters ??
                    Rajesh Etraju
                    Hi,

                    i had set everything as per the guidelines only ,like below..
                    For 30 Concurrent users :

                    Initital PoolSize : 33
                    Maximum Poolsize : 100
                    Referenced Pool Size : 10
                    Minimum Available Size : 5
                    Maximum Available Size: 20
                    Idle InstanceTimeOut : 120(sec)
                    Pool Pooling Interval : 60(sec)

                    Still same problem with the above mentioned settings.
                    Any more thoughts !!

                    --Rajesh