jdbc getConnection slow
Community,
We recently upgraded our Oracle RAC (two node cluster) database from Oracle 11 to 12.2.0.1.0. Our application platform is WebLogic 12.2.1.3 and JDK 1.8 and we connect to the database via scan listener. Since the database upgrade we have seen intermittent calls to the JDBC getConnection method take from 500 to over 1000 milliseconds. Typical response from getConnection is sub-millisecond. We see this happen both under low and high application load. We never saw this behavior prior to the database upgrade. Other than changing the database connection strings in the WebLogic JDBC pools there were no other changes to the