This discussion is archived
7 Replies Latest reply: Oct 28, 2013 10:59 AM by jgarry RSS

Omptimizer statastics !!

learner1 Newbie
Currently Being Moderated

Hi,

 

Source db : HP Unix with db 10.2.0.3 ( Enterprise Edition )

Target db : HP Unix with db 11.2.0.3 ( Enterprise Edition )

 

We are moving to new server , and i used oracle datapump to move user defined tablespaces. So i have 1 small question, i did NOT exclude statistics while doing export or import. Do you think i should exclude them & generate statistics on 11g system from scratch considering db version is diff. ? or it doesn't really matter ?

 

What is the general recommendations regarding statistics in this scenario ? Sorry i am still trying to learn performance related stuff at a bit slow and steady pace.

 

-Learner   

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points