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!

Gather Schema Statistic for SYS and SYSTEM

Beauty_and_dBestMar 31 2017 — edited Mar 31 2017

Hi all,

11gR2

Is it recommended to gather schema statistics for all schemas, including SYS and SYSTEM?

I have learned that there are tables that can be process fast if its stats are not updated? Is this true?

Please help...

Kind regards,

This post has been answered by AndrewSayer on Mar 31 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2017

Added on Mar 31 2017

#general-database-discussions

7 comments

2,923 views