AE using ILM hangs when calculating statistics

Document ID : KB000123074
Last Modified Date : 17/12/2018
Show Technical Document Details
Issue:
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;'
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.

 
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.