0 Replies Latest reply on Jan 17, 2014 8:59 AM by Sachidananda Dash

    Seeing lot of TIME_WAITS  from JBOSS AS 7.1.1 to DB even after the connection is closed.

    Sachidananda Dash Newbie

      Hi 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.