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!

concern over doing gather stats before upgrade db to 11.2.0.4

redologger-OCMar 28 2014 — edited Apr 3 2014

hi guys,

got my understand from the official guide using dbua to upgrade an database .

and Differences between GATHER STALE and GATHER AUTO (Doc ID 228186.1)

i have my performance concern regarding performing the steps prior to the upgrade.

Will it affect the performance of my database after the upgrade?

I am thinking in the line, that my database was working fine with my previous statistic.

correct me if i am wrong, this gathering of the statistic is is database wide right. And this include the dictionary also.

Is there a need for me to export all my tables statistic just in case i need to re -import them back ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2014
Added on Mar 28 2014
8 comments
3,954 views