You execute the following: EXECUTE DBMS_AuTO_TASK_ADMIN.DISABLE; Which advisor remains enabled?

The DBMSAUTOTASKADMIN.DISABLE procedure disables the automated maintenance task framework, which controls the execution of tasks within predefined maintenance windows. The tasks managed by this framework include the Automatic SQL Tuning Advisor, Automatic Segment Advisor, and Automatic Optimizer Statistics Collection. However, the collection of optimizer statistics is also fundamentally controlled by the STATISTICSLEVEL database parameter. Executing DBMSAUTOTASKADMIN.DISABLE stops the scheduled job, but it does not change the STATISTICSLEVEL parameter. Therefore, the feature of automatic statistics collection can be considered to remain enabled at the parameter level, even though its execution via the maintenance window is disabled.

A. The Automatic SQL Tuning Advisor is a client of the automated maintenance task framework and is disabled by this command.
B. The SQL Plan Management Evolve Advisor job is also managed by the automated maintenance task framework and is disabled.
C. The Optimizer Statistics Advisor runs as part of the Automatic Optimizer Statistics Collection task and is therefore disabled when the parent task is.
E. The Automatic Segment Advisor is a core client of the automated maintenance task framework and is disabled by this command.

1. Oracle Database PL/SQL Packages and Types Reference 19c, "DBMSAUTOTASKADMIN". Section: "DISABLE Procedure". (Describes disabling the autotask feature).

2. Oracle Database Reference 19c, "STATISTICSLEVEL". (Shows this parameter controls optimizer statistics collection, independent of the scheduler).

3. Oracle Database Administrator’s Guide 19c, Chapter 9, "Managing Automated Database Maintenance Tasks". (Lists the tasks controlled by the framework).