6 Replies Latest reply: Aug 13, 2013 10:06 PM by Hemant K Chitale RSS

    undoing dbms_stats.gather_table_stats config change

    Oracle-user2

      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