我不知道你是怎么查的,下面是我的,数据库版本11.2.0.1
=========================================
SQL> select TASK_NAME,TASK_TARGET_TYPE,TASK_TARGET_NAME,OPERATION_NAME,STATUS from dba_autotask_task;
TASK_NAME TASK_TARGET_TYPE
---------------------------------------------------------------- ----------------------------------------------------------------
TASK_TARGET_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATION_NAME STATUS
---------------------------------------------------------------- --------
AUTO_SQL_TUNING_PROG SQL Workload
automatic sql workload
automatic sql tuning task ENABLED
auto_space_advisor_prog System
system
auto space advisor job ENABLED
TASK_NAME TASK_TARGET_TYPE
---------------------------------------------------------------- ----------------------------------------------------------------
TASK_TARGET_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATION_NAME STATUS
---------------------------------------------------------------- --------
gather_stats_prog System
system
auto optimizer stats job ENABLED