0 Replies Latest reply: Mar 24, 2013 3:05 PM by user569151 RSS

    auto statistics collection not working most of time

      I have enabled auto statistics collection on dev/qa/pilot/prod environment. However none of them function right.

      For example:

      the next_start_date is behind after couple days good run:
      MAINTENANCE_WINDOW_GROUP TRUE 7 22-MAR-13 PM UTC Window group for Automated Maintenance
      ORA$AT_WGRP_OS TRUE 7 22-MAR-13 PM UTC auto optimizer stats collection
      ORA$AT_WGRP_SA TRUE 7 22-MAR-13 PM UTC auto space advisor
      ORA$AT_WGRP_SQ TRUE 7 22-MAR-13 PM UTC sql tuning advisor

      And then I would restart the scheduler thing by running following:
      SQL> @?/rdbms/admin/catnomwn.sql
      SQL> @?/rdbms/admin/catmwin.sql
      SQL> @?/rdbms/admin/utlrp.sql

      It will bring the next start date to the right date. However this cycle will happen again.

      I created SR with oracle, seems no response so far with a solution.

      So please help me here. I don't want to manually fix this issue forever.

      Thanks in advance.