Gather Schema Stats With Option Gather Fails To Collect Stats For Some Objects In Schema
(Doc ID 2692476.1)
Last updated on NOVEMBER 05, 2020
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Gathering schema stats using the below command.
exec dbms_stats.gather_schema_stats(ownname=>'<Schema Name>', CASCADE=>TRUE,estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, options=>'GATHER', degree => 4);
However it is not gathering stats for some tables. Check the below, it is showing different timestamp for all objects
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document