3 Replies Latest reply on May 4, 2012 2:58 PM by sb92075

    Partition Maintenance and Stats gathering running together

      Hi All,

      I have a scenario in my production database wherein Partition Maintenance and Stats Gathering jobs begin at the same time (both are run weekly on Sundays only).

      Partition Maintenance is a job which basically rebuilds indexes and creates new partitions on tables in the database. While Stats Gathering job gathers stats on database tables.

      My question was based on the scenario if we consider - Maintenance job is rebuilding indexes on a table and at the same time Stats gathering job is trying to gather stats for that same table. So will there be any issue caused due to this scenario ??

      I would like to know whether there is any issue with their running at the same time ?

      Database version: Oracle 10 R2
      Environment: Unix AIX version 5.3

      Thanks in advance.