Oracle DB - OEM Auto SQL Tuning Task 的建議分類

Advisor Central SQL Tuning Summary SYS.SYS_AUTO_SQL_TUNING_TASK 解析


Advisor Central  >   SQL Tuning Summary:SYS.SYS_AUTO_SQL_TUNING_TASK
的建議可以分為幾類:
1. Statistics
2. SQL Profile
3. Index
4. Restructure SQL
5. Alternative Plan
6. Miscellaneous

Reference:  How to find task exeution "EXEC_XXXX" from the Automatic SQL Tuning Results
https://forums.oracle.com/message/11025652

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?




1. sqlplus
select distinct t.TASK_ID
, t.TASK_NAME
, t.EXECUTION_START
, r.EXECUTION_NAME exec_name
from DBA_ADVISOR_TASKS t
, DBA_ADVISOR_RECOMMENDATIONS r
where t.TASK_ID=r.TASK_ID
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.