Multiple statistic calculation calls executed during Oracle ILM

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
U00003525 UCUDB: ===> 'begin uc_calc_stat (); end;'

During an Oracle ILM (Information Lifecycle Management) switch, multiple statistic calculations are called by different WPs and for the entire schema.  These calls can cause delays in the completion of the ILM switch.

Investigation

You may be encountering this issue if:

1. The Automation Engine (AE) is using an Oracle database.
2. During an Oracle ILM switch, delays are experienced.
3. In multiple WP logs the following message is seen:​

U00003525 UCUDB: ===> 'begin uc_calc_stat (); end;'

 

Cause

Cause type:
Defect
Root Cause: Schema statistics should only be calculated for the partitioned tables and once per day

Environment

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution

Update to a fix version listed below or a newer version if available.


 

Fix Status: Released

Fix Version(s):
Component(s): AE Server and Initialdata

Automation Engine 12.1.0 - Available
Automation Engine 12.0.3 - Available
Automation Engine 11.2.7 - Available

Additional Information

Workaround :
N/A

If this issue is significantly impacting your system during an ILM switch and you are unable to upgrade to a fixed version, please contact Automic Support for assistance.