1 Reply Latest reply on Nov 14, 2007 7:33 AM by Vicky Kak

    Help :too many process with Connection OCI

    Michele Tommaso Newbie

      hi,
      when I create a JDBC OCI connection on Linux server, i have 90 (!!) child processes owening to the main process that lock the server.

      My configuration is

      - vm: sun-jdk 1.6
      - JBoss 4.0.5 GA
      - driver : ojdbc14.jar (Oracle Client 10.2)
      - RAC ORACLE


      Oracle-ds.xml ------------------------------
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <connection-url>jdbc:oracle:oci:@IRES_WEB</connection-url>
      <min-pool-size>1</min-pool-size>
      <max-pool-size>20</max-pool-size>

      <user-name>xxxxx</user-name>
      xxxxxx



      Thanks
      Michele

        • 1. Re: Help :too many process with Connection OCI
          Vicky Kak Master

           

          "michele.tommaso" wrote:
          hi,
          when I create a JDBC OCI connection on Linux server, i have 90 (!!) child processes owening to the main process that lock the server.

          Investigate the thread dump when there is a lock on the server . figure out what threads are getting hanged .
          Who is spanning those 90 processes , are these spanned from your application ?