4 (active), 213 (available), 300 (max)系统运行一段时间后,数据库连接池监控情况如下,有大量活动的可用链接,对数据库和系统的压力特别大,导致影响系统速度,请高手支招!谢谢!附件Proxool的配置情况 jdbc-0.proxool.alias=DBPool
jdbc-0.proxool.driver-url=jdbc:oracle:thin:@192.168.1.2:1521:TESTORCL
jdbc-0.proxool.driver-class=oracle.jdbc.driver.OracleDriver
jdbc-0.user=nlcn
jdbc-0.password=nlcn
jdbc-0.proxool.house-keeping-sleep-time=40000
jdbc-0.proxool.house-keeping-test-sql=select 1 from dual
jdbc-0.proxool.maximum-connection-count=300
jdbc-0.proxool.minimum-connection-count=2
jdbc-0.proxool.maximum-connection-lifetime=18000000
jdbc-0.proxool.simultaneous-build-throttle=5
jdbc-0.proxool.recently-started-threshold=40000
jdbc-0.proxool.overload-without-refusal-lifetime=50000
jdbc-0.proxool.maximum-active-time=60000
jdbc-0.proxool.verbose=false
jdbc-0.proxool.trace=false
jdbc-0.proxool.fatal-sql-exception=Fatal error
jdbc-0.proxool.prototype-count=2
jdbc-0.proxool.statistics-log-level=ERROR
jdbc-0.proxool.test-before-use=false
jdbc-0.proxool.test-after-use=false
jdbc-0.proxool.driver-url=jdbc:oracle:thin:@192.168.1.2:1521:TESTORCL
jdbc-0.proxool.driver-class=oracle.jdbc.driver.OracleDriver
jdbc-0.user=nlcn
jdbc-0.password=nlcn
jdbc-0.proxool.house-keeping-sleep-time=40000
jdbc-0.proxool.house-keeping-test-sql=select 1 from dual
jdbc-0.proxool.maximum-connection-count=300
jdbc-0.proxool.minimum-connection-count=2
jdbc-0.proxool.maximum-connection-lifetime=18000000
jdbc-0.proxool.simultaneous-build-throttle=5
jdbc-0.proxool.recently-started-threshold=40000
jdbc-0.proxool.overload-without-refusal-lifetime=50000
jdbc-0.proxool.maximum-active-time=60000
jdbc-0.proxool.verbose=false
jdbc-0.proxool.trace=false
jdbc-0.proxool.fatal-sql-exception=Fatal error
jdbc-0.proxool.prototype-count=2
jdbc-0.proxool.statistics-log-level=ERROR
jdbc-0.proxool.test-before-use=false
jdbc-0.proxool.test-after-use=false
<!-- 自动检查连接是否断的测试sql语句 -->
<property name="houseKeepingTestSql">
<value>select sysdate() from dual</value>
</property>
<!-- 一个活动连接的最长时间15分钟,单位毫秒 -->
<property name="maximumActiveTime">
<value>900000</value>
</property>
<!-- 一个连接的最长活动时间4小时,单位毫秒 -->
<property name="maximumConnectionLifetime">
<value>14400000</value>
</property>
<property name="houseKeepingSleepTime">
<value>90000</value>
</property>
<property name="prototypeCount">
<value>5</value>
</property>
<property name="maximumConnectionCount">
<value>100</value>
</property>
<property name="minimumConnectionCount">
<value>10</value>
</property>
<property name="trace">
<value>true</value>
</property>
<property name="verbose">
<value>true</value>
</property>
</bean>http://topic.csdn.net/u/20090728/10/95c608fc-5065-4dd0-9f6d-7bc50cd0ff54.html还有我们当时的解决办法是增加了内存,加大了tomcat的启动连接数
默认好像是100,被我们老大改成了1000、没记错是的。
不懂楼主什么意思。没太明白。