Gather Schema Stats With Option Gather Fails To Collect Stats For Some Objects In Schema
(Doc ID 2692476.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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