ENABLE automatic statistics collection in 11g.

SQL> SHO PARAMETER STATISTICS_LEVEL

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

statistics_level                     string      TYPICAL

SQL> select client_name, status,attributes,service_name from dba_autotask_client;

CLIENT_NAME                              STATUS          ATTRIBUTES                                                   SERVICE_NAME

---------------------------------------- -------- ------------------------------------------------------------ ----------------------------

auto optimizer stats collection          DISABLED  ON BY DEFAULT, VOLATILE, SAFE TO KILL

auto space advisor                       ENABLED  ON BY DEFAULT, VOLATILE, SAFE TO KILL

sql tuning advisor                       ENABLED  ONCE PER WINDOW, ON BY DEFAULT, VOLATILE, SAFE TO KILL

SQL> select client_name,status from DBA_AUTOTASK_TASK;

CLIENT_NAME                              STATUS

---------------------------------------- --------

sql tuning advisor                       ENABLED

auto space advisor                       ENABLED

SQL> SELECT window_name,TO_CHAR(window_next_time,'DD-MON-YY HH24:MI:SS'),sql_tune_advisor, optimizer_stats, segment_advisor FROM DBA_AUTOTASK_WINDOW_CLIENTS;

WINDOW_NAME                    TO_CHAR(WINDOW_NEXT_TIME,'D   SQL_TUNE   OPTIMIZE   SEGMENT_

------------------------------ --------------------------- -------- -------- --------

MONDAY_WINDOW                  17-AUG-15 22:00:00          ENABLED  DISABLED ENABLED

TUESDAY_WINDOW                 18-AUG-15 22:00:00          ENABLED  DISABLED ENABLED

WEDNESDAY_WINDOW               19-AUG-15 22:00:00          ENABLED  DISABLED ENABLED

THURSDAY_WINDOW                13-AUG-15 22:00:00          ENABLED  DISABLED ENABLED

FRIDAY_WINDOW                  14-AUG-15 22:00:00          ENABLED  DISABLED ENABLED

SATURDAY_WINDOW                15-AUG-15 06:00:00          ENABLED  DISABLED ENABLED

SUNDAY_WINDOW                  16-AUG-15 06:00:00          ENABLED  DISABLED ENABLED

7 rows selected.

SQL>

SQL> SELECT  ENABLED FROM DBA_SCHEDULER_PROGRAMS WHERE PROGRAM_NAME = 'GATHER_STATS_PROG';

ENABL

-----

TRUE

Check if this table has any pending stats

SQL> select LAST_ANALYZED,NUM_ROWS from dba_TAB_PENDING_STATS where TABLE_NAME='TEST_TAB';

no rows selected

Enable optimizer stats :

SQL>  BEGIN

     DBMS_AUTO_TASK_ADMIN.ENABLE(

     client_name => 'auto optimizer stats collection',

     operation => NULL,

     window_name => NULL);

     END;

     / 

PL/SQL procedure successfully completed.

SQL> SELECT window_name,TO_CHAR(window_next_time,'DD-MON-YY HH24:MI:SS'),sql_tune_advisor, optimizer_stats, segment_advisor FROM DBA_AUTOTASK_WINDOW_CLIENTS;

WINDOW_NAME                TO_CHAR(WINDOW_NEXT_TIME,'D   SQL_TUNE   OPTIMIZE       SEGMENT_

------------------------------        ---------------------------         --------          --------         --------

MONDAY_WINDOW                17-AUG-15 22:00:00          ENABLED  ENABLED  ENABLED

TUESDAY_WINDOW               18-AUG-15 22:00:00           ENABLED  ENABLED  ENABLED

WEDNESDAY_WINDOW           19-AUG-15 22:00:00          ENABLED  ENABLED  ENABLED

THURSDAY_WINDOW                13-AUG-15 22:00:00          ENABLED  ENABLED  ENABLED

FRIDAY_WINDOW                   14-AUG-15 22:00:00          ENABLED  ENABLED  ENABLED

SATURDAY_WINDOW              15-AUG-15 06:00:00          ENABLED  ENABLED  ENABLED

SUNDAY_WINDOW                   16-AUG-15 06:00:00          ENABLED  ENABLED  ENABLED

7 rows selected.

Read more:

Automatic Statistics Collection (Doc ID 1233203.1)