14 Replies Latest reply: Feb 16, 2011 3:58 AM by Uwehesse-Oracle RSS

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

    user13322572
      All,

      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.

      Thanks.