Performance - EBS (MOSC)

MOSC Banner

Stale table statistics EBS 12.1.3

edited Jan 27, 2022 1:32PM in Performance - EBS (MOSC) 3 commentsAnswered ✓

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center