Help :too many process with Connection OCI

[michele.tommaso]

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

[vickyk]

"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 ?