This content has been marked as final. Show 6 replies
No. It means you are querying the wrong view. Try this and post the results.
SELECT client_name, status, mean_job_duration FROM dba_autotask_client;
Here are my results:
Thanks for your help!
1 auto optimizer stats collection ENABLED 2 auto space advisor ENABLED 3 sql tuning advisor ENABLED
Nothing is running when i query the job hsitory.
Am I querying the wrong place?
select client_name,window_name,to_char(job_start_time,'yy-mon-dd hh24:mi:ss') job_start_time,job_status from DBA_AUTOTASK_JOB_HISTORY; SELECT client_name, window_name, jobs_created, jobs_started, jobs_completed FROM dba_autotask_client_history WHERE client_name like '%stats%';
I found a better article:
I get now rows in the second query: “No rows selected, which obviously means that the Automatic SQL Tuning is enabled but the job has not been running."
How can I make the job to run?
Here is how to enable the task.
I am not sure if this will fix my issue.
Yes, enabling DBMS_AUTO_TASK_ADMIN fix my issue.