SELECT parameter_name, parameter_value FROM dba_advisor_parameters WHERE task_name = 'SYS_AUTO_SQL_TUNING_TASK' PARAMETER_NAME PARAMETER_VALUE ------------------------------ -------------------------------------------------- USERNAME UNUSED BASIC_FILTER UNUSED PLAN_FILTER UNUSED RANK_MEASURE1 UNUSED RANK_MEASURE2 UNUSED RANK_MEASURE3 UNUSED SQL_PERCENTAGE 1 SQL_LIMIT -1 RESUME_FILTER UNUSED LOCAL_TIME_LIMIT 1200 TEST_EXECUTE FULL APPLY_CAPTURED_COMPILENV UNUSED ACCEPT_SQL_PROFILES FALSE MAX_SQL_PROFILES_PER_EXEC 20 MAX_AUTO_SQL_PROFILES 10000 DAYS_TO_EXPIRE UNLIMITED END_SNAPSHOT UNUSED END_TIME UNUSED INSTANCE UNUSED JOURNALING INFORMATION MODE COMPREHENSIVE START_SNAPSHOT UNUSED START_TIME UNUSED TARGET_OBJECTS 1 TIME_LIMIT 3600 DEFAULT_EXECUTION_TYPE TUNE SQL ORA_EM_PARAM1 UNUSED ORA_EM_PARAM2 UNUSED ORA_EM_PARAM3 UNUSED ORA_EM_PARAM4 UNUSED ORA_EM_PARAM5 UNUSED ORA_EM_PARAM6 UNUSED ORA_EM_PARAM7 UNUSED ORA_EM_PARAM8 UNUSED ORA_EM_PARAM9 UNUSED ORA_EM_PARAM10 UNUSED EXECUTION_DAYS_TO_EXPIRE 30 SQL> select execution_name,status,execution_start,execution_end from dba_advisor_executions where task_name='SYS_AUTO_SQL_TUNING_TASK'; EXECUTION_NAME STATUS EXECUTION EXECUTION ------------------------------ ----------- --------- --------- EXEC_112 COMPLETED 02-JUN-13 02-JUN-13 EXEC_153 COMPLETED 03-JUN-13 03-JUN-13 EXEC_178 COMPLETED 04-JUN-13 04-JUN-13 EXEC_203 COMPLETED 05-JUN-13 05-JUN-13 EXEC_228 COMPLETED 06-JUN-13 06-JUN-13 EXEC_254 COMPLETED 07-JUN-13 07-JUN-13 EXEC_263 COMPLETED 08-JUN-13 08-JUN-13 EXEC_297 COMPLETED 29-JUN-13 29-JUN-13 EXEC_318 COMPLETED 30-JUN-13 30-JUN-13 EXEC_319 COMPLETED 30-JUN-13 30-JUN-13 EXEC_320 COMPLETED 30-JUN-13 30-JUN-13 EXEC_321 COMPLETED 30-JUN-13 30-JUN-13 EXEC_78 COMPLETED 31-MAY-13 31-MAY-13 EXEC_88 COMPLETED 01-JUN-13 01-JUN-13 14 rows selected. From the call stack kesutl_prs_idn() keshs_parse_profile_name() qsmoAlterPlans() kkopmCheckSmbUpdate DBA_ADVISOR_EXECUTIONS：获取有关各个任务执行的数据 DBA_ADVISOR_SQLSTATS：查看在测试 SQL 概要文件时生成的测试 - 执行统计信息 DBA_ADVISOR_SQLPLANS：查看在测试 - 执行过程中遇到的计划
执行该作业：exec DBMS_AUTO_SQLTUNE.EXECUTE_AUTO_TUNING_TASK(‘SYS_AUTO_SQL_TUNING_TASK’);