How to enable Oracle 11g automatic collection of statistics

Today received a friend database a case, in the DBCA, the automatic collection of statistical information to remove the option, the database run for six months did not collect statistical information, now to enable the following methods:

EXEC dbms_auto_task_admin. ENABLE ();

EXEC dbms_auto_task_admin. ENABLE (client_name => ' auto Optimizer stats collection ', Operation => ' auto optimizer stats job ',window_name=> NULL);

EXEC dbms_auto_task_admin. ENABLE (client_name => ' auto Optimizer stats collection ', Operation => null,window_name NULL);

Select Window_name,

Window_next_time,

Optimizer_stats,

Aa. Window_active,

Aa. Segment_advisor,

Aa. Autotask_status,

Aa. Optimizer_stats

From Dba_autotask_window_clients AA

ORDER BY Window_next_time

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/