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 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

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

Cause

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
Symptoms
Cause
Solution


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