This discussion is archived
6 Replies Latest reply: Aug 13, 2013 8:06 PM by Hemant K Chitale RSS

undoing dbms_stats.gather_table_stats config change

Oracle-user2 Newbie
Currently Being Moderated

hi gurus

 

gather table stats config has been changed in the hope to improve performance. however, this change impacted negatively. and rolling back the config changes didn't give us the earlier better performance i.e. even after reverting the gather table stats config, the job is still taking too much time...any ideas in whatever clean up has to be done whereever will be helpful

 

thanks

Legend

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