Stale table statistics EBS 12.1.3
Hi Team,
i can see that in our EBS 12.1.3 environment (database 12.1.0.2.0) we have tables with stale statistics. Concurrent program that runs every day completing with no error but still there are staled statistics tables.
Can you please tell me is it safe to collect stale statics manually by executing this line:
exec apps.fnd_stats.gather_schema_statistics(schemaname=> 'ALL',estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,options => 'GATHER AUTO');
Also to mention by looking document 1586374.1 it seems that we do not have patch 16410424:R12.FND.B applied, so probably this is a reason why we have stale table stats after scheduled program Gather Schema Statistics is executed?