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

When you execute DBMS_AUTO_TASK_ADMIN.DISABLE, it disables all automated maintenance tasks

related to the Auto Task framework. This includes tasks such as the Automatic SQL Tuning Advisor,

Automatic Segment Advisor, and others. However, the Automatic Optimizer Statistics Collection (D)

remains enabled as it is not part of the Auto Task framework. The gathering of optimizer statistics is

controlled separately and is a critical part of the database's self-tuning mechanism to ensure the

optimizer has up-to-date information about the data distribution within tables and indexes.

Reference

Oracle Database 19c PL/SQL Packages and Types Reference - DBMS_AUTO_TASK_ADMIN

Oracle Database 19c Database Administrator’s Guide - Managing Optimizer Statistics