search

brettwooldridge / HikariCP

光 HikariCP・A solid, high-performance, JDBC connection pool at last.
Apache License 2.0
20k stars 2.93k forks source link

HikariCP for Oracle RAC #1913

Open dba9999 opened 2 years ago

dba9999 commented 2 years ago

Below is the hikari config my application team is using. We are seeing a 100's of logon/logoff events per min in the Oracle database. Could you please shed light on why we are seeing such behavior?

spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver logging.level.com.zaxxer.hikari.HikariConfig=DEBUG spring.datasource.hikari.connection-timeout=2000 spring.datasource.hikari.maximum-pool-size=30 spring.datasource.hikari.pool-name=springHikariConnection spring.datasource.hikari.max-lifetime=1800000 spring.datasource.hikari.idle-timeout=1000 spring.datasource.hikari.allow-pool-suspension=true

quaff commented 2 years ago

idle-timeout=1000 means connection will be closed if not used in next 1 second.