My Oracle Support Banner

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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.