Oracle: Disabling the auto space advisor background task
To prevent deadlocks during migration, you must complete a task to disable the Oracle background task called "Auto Space Advisor" before your run the upgrade-profile task during migration using the Configuration Wizard. After you complete migration, you can enable "Auto Space Advisor" as a post-migration task.
Before you begin
SQL> select status from dba_autotask_client where client_name = 'auto space advisor';
Procedure
Enter the following SQL:
BEGIN
dbms_auto_task_admin.disable(
client_name => 'auto space advisor',
operation => NULL,
window_name => NULL);
END;
/
Note: If you do not turn off the "Auto
Space Advisor," it is possible for the migration to fail with the
following Oracle error: ORA-00060: deadlock detected while waiting
for resource.