This content has been marked as final. Show 5 replies
As mentioned before you can find your answer in the link.
In the concerned database you can enable the automatic optimizer statistics collection by (as user sys):
client_name => 'auto optimizer stats collection',
operation => NULL,
window_name => NULL);
You can querie DBA_AUTOTASK_CLIENT to see if the task is now enabled.