Skip to Main Content

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,

jc

This post has been answered by AndrewSayer on Mar 31 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2017
Added on Mar 31 2017
7 comments
2,923 views