Oracle Table Analyze job not calculating all stats on Oracle 19(DE60405)

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Oracle Table Analyze job not calculating all database statistics with histograms on Oracle 19

STEPS TO REPRODUCE:
1. On Clarity with Oracle 19, run Oracle Table Analyze job

Expected Results: The job to calculate stats correctly

Actual Results: Some stats are not calculated right, which may lead to latency in queries and performance problems 

 

Environment

Release : 15.8.1, 15.9, 15.9.1 and Oracle 19

Resolution

Workaround: Run the following command to update the stats:

exec dbms_stats.gather_schema_stats(ownname=>'CLARITY', CASCADE=>TRUE,ESTIMATE_PERCENT=>dbms_stats.auto_sample_size,degree => DBMS_STATS.AUTO_DEGREE);

This can be scheduled by the DBA as a database job regularly

Solution:

This is DE60405, fixed in 15.9.2