I CREATE 2 DB TOW WEEK AGO.
Auto task is ok in one of them, but is not ok in the other DB.
(auto optimizer stats collection ,auto space advisor ,sql tuning advisor)
I run SQLs in 2 DB.
It show diffent results.
<<Ok DB>>
select window_name, window_next_time-systimestamp nextgap, window_next_time
from dba_autotask_window_clients
order by window_next_time;
WINDOW_NAME NEXTGAP WINDOW_NEXT_TIME
-------------------- ---------------------------- ----------------------------------------
MONDAY_WINDOW +000000000 10:21:54.497951 10-OCT-16 10.00.00.000000 PM ASIA/SEOUL
TUESDAY_WINDOW +000000001 10:21:54.497951 11-OCT-16 10.00.00.000000 PM ASIA/SEOUL
WEDNESDAY_WINDOW +000000002 10:21:54.497951 12-OCT-16 10.00.00.000000 PM ASIA/SEOUL
THURSDAY_WINDOW +000000003 10:21:54.497951 13-OCT-16 10.00.00.000000 PM ASIA/SEOUL
FRIDAY_WINDOW +000000004 10:21:54.497951 14-OCT-16 10.00.00.000000 PM ASIA/SEOUL
SATURDAY_WINDOW +000000004 18:21:54.497951 15-OCT-16 06.00.00.000000 AM ASIA/SEOUL
SUNDAY_WINDOW +000000005 18:21:54.497951 16-OCT-16 06.00.00.000000 AM ASIA/SEOUL
7 rows selected.
select client_name,status from dba_autotask_client order by client_name;
CLIENT_NAME STATUS
---------------------------------------- ----------------
auto optimizer stats collection ENABLED
auto space advisor ENABLED
sql tuning advisor DISABLED
select client_name,status from dba_autotask_task order by client_name;
CLIENT_NAME STATUS
---------------------------------------- ----------------
auto optimizer stats collection ENABLED
auto space advisor ENABLED
sql tuning advisor ENABLED
<< NOT OK DB>>
select window_name, window_next_time-systimestamp nextgap, window_next_time
from dba_autotask_window_clients
order by window_next_time;
WINDOW_NAME NEXTGAP WINDOW_NEXT_TIME
-------------------- ---------------------------- ----------------------------------------
WEDNESDAY_WINDOW -000000011 13:37:35.038740 28-SEP-16 10.00.00.000000 PM ASIA/SEOUL
THURSDAY_WINDOW -000000010 13:37:35.038740 29-SEP-16 10.00.00.000000 PM ASIA/SEOUL
FRIDAY_WINDOW -000000009 13:37:35.038740 30-SEP-16 10.00.00.000000 PM ASIA/SEOUL
SATURDAY_WINDOW -000000009 05:37:35.038740 01-OCT-16 06.00.00.000000 AM ASIA/SEOUL
SUNDAY_WINDOW -000000008 05:37:35.038740 02-OCT-16 06.00.00.000000 AM ASIA/SEOUL
MONDAY_WINDOW -000000006 13:37:35.038740 03-OCT-16 10.00.00.000000 PM ASIA/SEOUL
TUESDAY_WINDOW -000000005 13:37:35.038740 04-OCT-16 10.00.00.000000 PM ASIA/SEOUL
7 rows selected.
select client_name,status from dba_autotask_client order by client_name;
CLIENT_NAME STATUS
---------------------------------------- ----------------
auto optimizer stats collection ENABLED
auto space advisor ENABLED
sql tuning advisor ENABLED
select client_name,status from dba_autotask_task order by client_name;
no rows selected