How to remove the statistics scheduled on the data dictionary?
Customer is trying to remove a scheduled job that is gathering statistics on dictionary.
Doing exec dbms_stats.delete_dictionary_stats(); the requests work fine, but as this
seems to be caused by a job it is needed to stop it.
The Database version is 11.2.0.3.
I could not find how to do this, we could use DBMS_SCHEDULER.DROP_JOB, we could
find it through the ALL_SCHEDULER_JOBS/DBA_SCHEDULER_JOBS; but they are on 11.2.
so we look in DBA_AUTOTASK_CLIENT but with this information, all the statistics will be
disable, not just the dictionary.
Any idea how can do this?
Thanks,
Deyanira