auto optimizer stats collection Job not running
Even though the auto task jobs are enabled we have observed that they are not running.
1* select CLIENT_NAME,STATUS,CONSUMER_GROUP,WINDOW_GROUP from dba_autotask_client
SQL> /
CLIENT_NAME STATUS CONSUMER_GROUP WINDOW_GROUP
---------------------------------------- -------- -------------------- ------------------------------
auto optimizer stats collection ENABLED ORA$AUTOTASK ORA$AT_WGRP_OS
auto space advisor ENABLED ORA$AUTOTASK ORA$AT_WGRP_SA
sql tuning advisor ENABLED ORA$AUTOTASK ORA$AT_WGRP_SQ
Last week we had an issue in prod when the cpu utilization was almost 100% when the gather stats were runningand awr report shows Resmgr:Cpu Quantum wait event. So as per the