Multiple statistic calculation calls executed during Oracle ILM

Document ID : KB000084743
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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
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.