需要改一下proxool中的配置文件中,最后的部分,参数改大点
jdbc-0.proxool.maximum-connection-count=50
jdbc-0.proxool.minimum-connection-count=10
jdbc-0.proxool.prototype-count=4
jdbc-0.proxool.house-keeping-test-SQL=SELECTCURRENT_DATE
jdbc-0.proxool.verbose=true
jdbc-0.proxool.statistics=10s,1m,1d
jdbc-0.proxool.statistics-log-level=DEBUG
jdbc-0.proxool.house-keeping-sleep-time=30000
jdbc-0.proxool.maximum-connection-lifetime=1800000
jdbc-0.proxool.simultaneous-build-throttle=20
jdbc-0.proxool.overload-wIThout-refusal-lifetime=10000
jdbc-0.proxool.maximum-active-time=50000
jdbc-0.proxool.trace=true
jdbc-0.proxool.fatal-SQL-exception=ORA-1234
jdbc-0.proxool.prototype-count=2
同时软件-基本信息,数据源的连接池也需要改大 |