In 12.2 Auto Space Advisor Job Fails With ORA-60 (Doc ID 2321020.1)
After upgrade to 12.2 , space advisor job fails and the following message appears on the alert log:
ORA-00060: deadlock resolved; details in file /opt/oracle/diag/rdbms/oratest/oratest/trace/oratest_j001_162692.trc <<< Deadlock Trace File
Errors in file /opt/oracle/diag/rdbms/oratest/oratest/trace/oratest_j001_162692.trc
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_2629"
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "SYS.DBMS_SPACE", line 2741
ORA-06512: at "SYS.DBMS_HEAT_MAP_INTERNAL", line 716
ORA-06512: at "SYS.DBMS_HEAT_MAP_INTERNAL", line 1164
ORA-06512: at "SYS.DBMS_HEAT_MAP", line 228
Oracle provides any patch to fix this problem?