14 Replies Latest reply on Feb 16, 2011 9:58 AM by Uwehesse-Oracle

    Disable Auto Gather Stats on 11g r2 For a few tables


      I am on 11g r2 and there is a auto gather stats program which run's during its maintenance window's.

      I want to disable this job for only partitioned tables and want to run it normally for the non-partitioned ones.

      So in short can we modify this auto stats gather program to exclude partitioned tables. If yes could I know how to do this.