SQL Performance (MOSC)

MOSC Banner

Statistics Advisor Executing for Long Time

edited Aug 31, 2018 5:03AM in SQL Performance (MOSC) 10 commentsAnswered ✓

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
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center