Statistics Advisor Executing for Long Time
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
I just found out about the statistics advisor feature and I am starting using it.
I was reading that this task runs automatically in the maintenance window, yet when I query DBA_ADVISOR_EXECUTIONS, I see that the latest execution was like 5 months ago and it even shows that it is still executing.
SELECT * FROM (SELECT TASK_NAME, EXECUTION_START, EXECUTION_LAST_MODIFIED, EXECUTION_END, ADVISOR_NAME, STATUS, STATUS_MESSAGE, ERROR_MESSAGE FROM DBA_ADVISOR_EXECUTIONS WHERE TASK_NAME = 'AUTO_STATS_ADVISOR_TASK' ORDER BY execution_end DESC) WHERE ROWNUM <= 5
TASK_NAME |