AE using ILM hangs when calculating statistics
Article ID: 123074
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
The AE hangs with Time Critical DB calls related to the following query:
U00003525 UCUDB: ===> 'begin DBMS_STATS.gather_table_stats(ownname => ? , tabname => ?, partname => ?, estimate_percent=>100, cascade=>true,method_opt=>'FOR ALL INDEXED COLUMNS SIZE REPEAT'); end;'
U00003525 UCUDB: ===> 'begin DBMS_STATS.gather_table_stats(ownname => ? , tabname => ?, partname => ?, estimate_percent=>100, cascade=>true,method_opt=>'FOR ALL INDEXED COLUMNS SIZE REPEAT'); end;'
Environment
This can happen in large systems where ILM is activated
Cause
The issue is related to a statistics routine in the AE that takes very long time to finish and consumes all resources on the machine
In short, the stored procedure 'uc_calc_stat' tries to calculate statistics for the AE tables that undergo change all the time.
In short, the stored procedure 'uc_calc_stat' tries to calculate statistics for the AE tables that undergo change all the time.
Resolution
Solution:
Since calculating statistics it is not the task of the AE you can safely turn this functionality off.
Turning statistics off is done by setting UC_ILM_SETTINGS > STATISTIC_TIME=0
It up to the DBA to decide if statistics need to be calculated and to do this outside the AE.
Since calculating statistics it is not the task of the AE you can safely turn this functionality off.
Turning statistics off is done by setting UC_ILM_SETTINGS > STATISTIC_TIME=0
It up to the DBA to decide if statistics need to be calculated and to do this outside the AE.
Feedback
Yes
No
Powered by
