I have enabled auto statistics collection on dev/qa/pilot/prod environment. However none of them function right.
the next_start_date is behind after couple days good run:
MAINTENANCE_WINDOW_GROUP TRUE 7 22-MAR-13 10.00.00.000000 PM UTC Window group for Automated Maintenance
ORA$AT_WGRP_OS TRUE 7 22-MAR-13 10.00.00.000000 PM UTC auto optimizer stats collection
ORA$AT_WGRP_SA TRUE 7 22-MAR-13 10.00.00.000000 PM UTC auto space advisor
ORA$AT_WGRP_SQ TRUE 7 22-MAR-13 10.00.00.000000 PM UTC sql tuning advisor
And then I would restart the scheduler thing by running following:
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.