|
SQL> select * from DBA_AUTOTASK_CLIENT;
CLIENT_NAME STATUS CONSUMER_GROUP CLIENT_TAG PRIORITY_OVERRIDE ATTRIBUTES WINDOW_GROUP SERVICE_NAME RESOURCE_PERCENTAGE USE_RESOURCE_ESTIMATES MEAN_JOB_DURATION MEAN_JOB_CPU MEAN_JOB_ATTEMPTS MEAN_INCOMING_TASKS_7_DAYS MEAN_INCOMING_TASKS_30_DAYS TOTAL_CPU_LAST_7_DAYS TOTAL_CPU_LAST_30_DAYS MAX_DURATION_LAST_7_DAYS MAX_DURATION_LAST_30_DAYS WINDOW_DURATION_LAST_7_DAYS WINDOW_DURATION_LAST_30_DAYS
---------------------------------------------------------------- -------- ------------------------------ ---------- ----------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ------------------- ---------------------- ----------------------------------------------------------- ----------------------------------------------------------- ----------------- -------------------------- --------------------------- ----------------------------------------------------------- ----------------------------------------------------------- ----------------------------------------------------------- ----------------------------------------------------------- ----------------------------------------------------------- -----------------------------------------------------------
auto optimizer stats collection ENABLED ORA$AUTOTASK_STATS_GROUP OS INVALID ON BY DEFAULT, VOLATILE, SAFE TO KILL ORA$AT_WGRP_OS 25 FALSE
auto space advisor ENABLED ORA$AUTOTASK_SPACE_GROUP SA INVALID ON BY DEFAULT, VOLATILE, SAFE TO KILL ORA$AT_WGRP_SA 25 FALSE
sql tuning advisor ENABLED ORA$AUTOTASK_SQL_GROUP SQ INVALID ONCE PER WINDOW, ON BY DEFAULT, VOLATILE, SAFE TO KILL ORA$AT_WGRP_SQ 25 FALSE
SQL> select * from DBA_AUTOTASK_WINDOW_CLIENTS;
WINDOW_NAME WINDOW_NEXT_TIME WINDOW_ACTIVE AUTOTASK_STATUS OPTIMIZER_STATS SEGMENT_ADVISOR SQL_TUNE_ADVISOR HEALTH_MONITOR
------------------------------ -------------------------------------------------------------------------------- ------------- --------------- --------------- --------------- ---------------- --------------
MONDAY_WINDOW 19-1月 -15 10.00.00.000000 下午 PRC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
TUESDAY_WINDOW 20-1月 -15 10.00.00.000000 下午 PRC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
WEDNESDAY_WINDOW 21-1月 -15 10.00.00.000000 下午 PRC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
THURSDAY_WINDOW 22-1月 -15 10.00.00.000000 下午 PRC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
FRIDAY_WINDOW 16-1月 -15 10.00.00.000000 下午 PRC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
SATURDAY_WINDOW 17-1月 -15 06.00.00.000000 上午 PRC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
SUNDAY_WINDOW 18-1月 -15 06.00.00.000000 上午 PRC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
7 rows selected
SQL> select sysdate from dual;
SYSDATE
-----------
2015/3/5 9:
SQL>
如上,JOB时间竟然是1月。。。 搜索了下也没有找到如何解决这个的,试过关闭JOB后重新开启还是没有用
|
|