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

Omptimizer statastics !!

learner1 Newbie
Currently Being Moderated



Source db : HP Unix with db ( Enterprise Edition )

Target db : HP Unix with db ( 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.




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