You execute the following:EXECUTE DBMS_AuTO_TASK_ADMIN.

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.

References

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

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