Multiple statistic calculation calls executed during Oracle ILM

Article Id: 84743
Status: Published
Updated On: 15-04-2018 08:01
Legacy Id: 000009650
Products:
CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION
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.