[AWA] WP memory usage increases over time after upgrade Oracle database
book
Article ID: 145127
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
After upgrading of Oracle database, AE processes consume memory without releasing. - Oracle database was upgraded from 12.1 to 12.2 - Since then system processes (CP & WP) occupied more and more memory overtime until server's RAM is exhausted - Upgrading AE from 12.2.1HF4 to 12.3.1 and the issue still persists. - Another environment with original AE 12.2.1HF4 works normally.
Environment
Release : 12.3
Component : AUTOMATION ENGINE
Cause
Analysis from R&D: - If AE core is still the same, the only change to the environment was the new Oracle version, then the cause must be an issue with Oracle client.
Resolution
Upgrade to corresponding oracle client and the issue does not appear anymore.