4 Replies Latest reply on Feb 17, 2009 3:05 PM by Sreelatha Reddy

    Stress test - ORA-00020: maximum number of processes (150) e

    Sreelatha Reddy Newbie

      Hi,

      My java application on JBoss-4.2.2 is running on 2GB machine, and I am using JMeter to stress test. JBoss is running as Windows Service (using JavaServiceWrapper), and trying to figure out optimum values for JAVA_OPTS in wrapper.conf.

      wrapper.java.initmemory=600
      wrapper.java.maxmemory=1200
      wrapper.java.additional.3=-Xms2048m
      wrapper.java.additional.4=-Xmx2048m


      When I send 1000 requests in 1 second, memory seems to be okay, but I see lot of 'ORA-00020: maximum number of processes (150) exceeded' errors in logs. I am not sure where this process value gets set.

      In context.xml (jboss-4.2.2\server\default\deploy\jboss-web.deployer) I have
      maxActive="200" maxIdle="10"
      , and in oralce-ds.xml (jboss-4.2.2\server\default\deploy) I have
      <min-pool-size>5</min-pool-size> <max-pool-size>200</max-pool-size>


      Any suggestions on how to increase 'Process' count?

      Thanks,
      Jacike.