DBMS_AUTO_TASK_ADMIN.ENABLE does not collect statistics automatically?
Posted on 2014-03-08
I executed the below in my oracle 11g, but still no automatic statistics.
I am checking the analyzed column in user_tables, still showing old date.
Is there any other parameter I need to change/set?
DBMS_AUTO_TASK_ADMIN.ENABLE( client_name => 'auto optimizer stats collection', operation => NULL, window_name => NULL);
Also the flag "GATHER_STATS_JOB" is diabled, should I need to make it true.?