6 Replies Latest reply on Aug 14, 2013 3:06 AM by Hemant K Chitale

    undoing dbms_stats.gather_table_stats config change


      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