Oracle: Enable the auto space advisor background task

If we use an Oracle database, complete a post-migration task to enable the Oracle background task called "Auto Space Advisor" after the run the upgrade-profile task during migration using the Configuration Wizard.

Enter the following SQL:

BEGIN
 dbms_auto_task_admin.enable(
  client_name => 'auto space advisor',   operation  => NULL,   window_name => NULL);
END;
/

What to do next

To ensure that we enabled the "Auto Space Advisor" task, we can check whether the task is enabled or disabled by entering the following command from SQL Plus:

SQL> select status from dba_autotask_client where client_name = 'auto space advisor';

Parent Database tasks

Related tasks:

Oracle: Disabling the auto space advisor background task