Automatic Statistics Job
Hi Gurus,
I am wondering why the statistics are not gathered for any of my tables and indexes though Automatic gathering of CBO statistics is enabled. Please see the details:
1. SQL> select client_name, JOB_SCHEDULER_STATUS from DBA_AUTOTASK_CLIENT_JOB where client_name='auto optimizer stats collection';
no rows selected
2. SQL> SELECT ENABLED FROM DBA_SCHEDULER_PROGRAMS WHERE PROGRAM_NAME = 'GATHER_STATS_PROG';
ENABL
-----
TRUE
3. SQL> SELECT client_name, window_name, jobs_created, jobs_started, jobs_completed FROM dba_autotask_client_history WHERE client_name like '%stats%';
no rows selected
4. SQL> select client_name,status from Dba_Autotask_Client;