JWP memory leak using Oracle JDBC-OCI driver

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

JWP seem to be having memory leak issues each time the index rebuild is triggered, generating a heap dump.

We are using  Oracle JDBC-OCI driver and the connect string in the UCSRV.ini file looks like: 

SQLDRIVERCONNECT=jdbc:oracle:oci:@xxxxx

Environment

• CA Automic Workload Automation 21.x
• Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
• Oracle JDBC-OCI driver
• Openjdk version "11.0.20" 2023-07-18 LTS

Cause

Known memory leak using Oracle 19 when using Oracle JDBC-OCI driver

 

Resolution

Please switch to using  Oracle JDBC-THIN driver, and the connection string should look something  like SQLDRIVERCONNECT=jdbc:oracle:thin:@xxxxx.

Additional Information

There is a known memory leak with Oracle19 - see reference link below:
https://www.ibm.com/support/pages/possible-memory-leak-if-oracle-jdbc-oci-driver-used-when-enabling-websphere-application-server-connection-pooling