This content has been marked as final. Show 5 replies
What is the EM version?
The question has not much to do with EM but is database related.
For the answer see http://docs.oracle.com/cd/E11882_01/server.112/e16638/stats.htm 13.2.1 Enabling and Disabling Automatic Optimizer Statistics Collection
That's not entirely correct. Auto stats collection is part of the auto-task framework job that can be enabled via EM. If you tell me which versuion of EM, I can tell you how to enable it via EM.
EM version 18.104.22.168.0
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.