Seeing lot of TIME_WAITS from JBOSS AS 7.1.1 to DB even after the connection is closed.
sachi.dash Jan 17, 2014 8:59 AMHi All,
I am seeking a big help. help highly appreciated.
One of my application is heavily loaded application. We recently migrated from JBOSS 5 to JBOSS7.1.1.
Observation:
1. At peak load the application server behaves very slow.
2. Seeing lots of TIME_WAIT originated for the db connection created from App server to database, around 300+ even goes to some times
3. At the peak when queried the database for the active connection hardly I see around 60 active connection originated from the same instance.
When the TIME_WAIT keeps on increasing , we start seeing the slowness.
Sharing the DB configuration details from standalone.xml
===============================================
<datasource jta="true" jndi-name="java:/xyz" pool-name="USpecOracleDS" enabled="true" use-java-context="true" spy="true" use-ccm="true">
<connection-url>----------------------------</connection-url>
<driver>oracle</driver>
<new-connection-sql>Alter session SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI'</new-connection-sql>
<pool>
<min-pool-size>20</min-pool-size>
<max-pool-size>400</max-pool-size>
<prefill>true</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>IdleConnections</flush-strategy>
</pool>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<background-validation>true</background-validation>
</validation>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
<use-fast-fail>false</use-fast-fail>
</validation>
<timeout>
<set-tx-query-timeout>true</set-tx-query-timeout>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>0</idle-timeout-minutes>
<query-timeout>600</query-timeout>
</timeout>
<statement>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<share-prepared-statements>true</share-prepared-statements>
</statement>
</datasource>
====================================================================
Can any body help me this.