Reviewing Automated DB Jobs for EBS Best Practices

You should use the DBA Automated Maintenance Tasks report. It queries the status and history of automated jobs and advisors using views like `dba_autotask_operation`.

For EBS, the automated statistics collection must be deactivated by setting the DB initialization parameter `_optimizer_autostats_job=false`. The concurrent program ‘Gather Schema Statistics’ should be scheduled instead.

ADDM can be deactivated in non-actively monitored environments by setting `alter system set “_addm_auto_enable”=false`. The DBA AWR reports often provide better, more detailed insights than ADDM into performance bottlenecks.

To disable the SQL Tuning Advisor manually, execute: `exec dbms_auto_task_admin.disable(client_name=>’sql tuning advisor’, operation=>null, window_name=>null);`.