More About SYS_AUTO_SQL_TUNING_TASK

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:查看在测试 - 执行过程中遇到的计划

Comments

  1. 执行该作业:exec DBMS_AUTO_SQLTUNE.EXECUTE_AUTO_TUNING_TASK(‘SYS_AUTO_SQL_TUNING_TASK’);

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号