Does anybody knows how to find a specific run of an Automatic SQL Tuning Advisor in EM 12c?
Very often on the page SQL Tuning Details:SYS.SYS_AUTO_SQL_TUNING_TASK I see the following result:
"This statement was skipped because it has already been tuned recently. See task execution "EXEC_5616" for the most recent tuning results." Fine, but how to find this specific task execution? I'm not able to find any task execution. Does it possible to find it at all?
Thanks in advance,
select distinct t.TASK_ID
, r.EXECUTION_NAME exec_name
from DBA_ADVISOR_TASKS t
, DBA_ADVISOR_RECOMMENDATIONS r
and r.EXECUTION_NAME = 'EXEC_6802'
2. OEM -> 'Advisor Central' -> SEARCH FOR TASK_NAME from the output of SQL statement above
4. On the 'Results' section, click the task name and you should be able to see the SQL tuning recommendations.
Kirill Loifman, dadbm.com