Stats Job is Collecting Stats For Partitions That Are Not Loaded Daily
(Doc ID 2433684.1)
Last updated on AUGUST 16, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
- Auto statistics is collecting statistics for partitions that are not loaded daily
- Set tracing which shows following message:
exec DBMS_STATS.SET_GLOBAL_PREFS('trace', 4+8+16+64+512+1024+2048 /* 3676 */);
'Need larger sample for density calculation'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!