Jboss connection pool has high TotalBlockingTime
eric2 Jan 4, 2013 6:25 PMI have a lot of blocked threads all on this stacktrace:
Stack Trace:
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getConnectionProperties(BaseWrapperManagedConnectionFactory.java:1005)
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:490)
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:282)
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
Not all of the connections are handed out, yet I see a lot of wait time trying to get a connection to the db.
statistics.pool.ActiveCount | 60 |
statistics.pool.AvailableCount | 46 |
statistics.pool.AverageBlockingTime | 33731 |
statistics.pool.AverageCreationTime | 756 |
statistics.pool.CreatedCount | 79 |
statistics.pool.DestroyedCount | 19 |
statistics.pool.MaxCreationTime | 2310 |
statistics.pool.MaxUsedCount | 60 |
statistics.pool.MaxWaitTime | 1976 |
statistics.pool.TimedOut | 19 |
statistics.pool.TotalBlockingTime | 2664779 |
statistics.pool.TotalCreationTime | 59753 |
standalone.xml
<datasources>
<datasource jta="false" jndi-name="java:jboss/datasource/oracle" pool-name="oracle" enabled="true" use-ccm="false">
<connection-url>jdbc:oracle:thin:@//produt-scan.ora.ut.us.attask.com/cl2load</connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<driver>oracle</driver>
<pool>
<min-pool-size>20</min-pool-size>
<max-pool-size>60</max-pool-size>
<prefill>true</prefill>
</pool>
<security>
<security-domain>encryptedoracle-ds</security-domain>
</security>
<validation>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
</validation>
<statement>
<prepared-statement-cache-size>10</prepared-statement-cache-size>
<share-prepared-statements>true</share-prepared-statements>
</statement>
</datasource>