Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

global stats and user stats

don123Oct 6 2022

We are using Oracle Database 12c 12.2.0.1.0
I understand from documentation that GLOBAL_STATS are applicable when tables are partitioned.
I see from all_tables that tables are not partitioned in the schema, PARTITIONED=NO
But I see from all_tab_statistics GLOBAL_STATS=YES and USER_STATS=NO for all tables in the schema.
Do I need to gather statistics again ?

This post has been answered by Solomon Yakobson on Oct 9 2022

Jump to Answer

Added on Oct 6 2022

#general-database-discussions

6 comments

2,697 views