AE using ILM hangs when calculating statistics

Document ID : KB000123074
Last Modified Date : 17/12/2018
Show Technical Document Details
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;'
This can happen in large systems where ILM is activated
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.

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.