ORA-00060: deadlock resolved; details in file /home/oracle/diag/rdbms/ORCL/ORCL/trace/ORCL_j001_200521.trc
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_5723"
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 < ORA-06512: at "SYS.DBMS_SPACE", line 2747
After investigation found that there is a bug in 12.2 Release and Oracle working to it. You can refer below oracle support notes on this.
Bug 24687075 - SPACE ADVISOR TASKS/JOBS HITTING DEADLOCKS WITH GATHER DB STATS JOBS
In 12.2 Auto Space Advisor Job Fails With ORA-60 (Doc ID 2321020.1)
If you have setup alerts for ORA- errors then either you add exclusions to your script or you can run below command to disable the job Until Bug 24687075 gets fixed
SQL> EXEC DBMS_AUTO_TASK_ADMIN.DISABLE('AUTO SPACE ADVISOR',NULL, NULL);
Regards
Satishbabu Gunukula, Oracle ACE
ReplyDeletethis was an exceptionally nice post. Taking a few minutes and actual effort to generate a really good article
شركة نقل عفش
شركة نقل اثاث بالرياض رخيصة
اقوى شركات تنظيف خزانات المياه بجدة تلك التي تقوم بأعمال تنظيف وتعقيم خزانات المياه في جدة بمنتهى الدقة والاحترافية وتقدم ايضا شركة تنظيف خزانات بجده افضل الخدمات الجيدة في تنظيف وتعقيم الخزانات لكي تحافظ على الماء نظيفا ومعقما اطول فترة زمنية ممكنة لكي تكون مياهك نظيفة فان شركه نظافة خزانات مستعدة لاستقبال مكالمتكم
ReplyDeleteشركة مكافحة حشرات بالخبر
ReplyDeleteشركة مكافحة حشرات بالجبيل
شركة مكافحة حشرات بالاحساء
WB HS Question Paper 2023 Academic year are now officially Published in at Official Website. Students eagerly looking for the West Bengal 11th & 12th Class Model Paper 2023 can Download them now either from the Our website or from the links provided below. West Bengal 11th important Questions 2023 Get the Complete Details about the WBCHSE Board 11th & 12th Class Question Paper 2023. WBCHSE 11th & 12th Class Previous Question Paper 2023 have Mostly Repeated important Questions 2023 asked in Every year. So, Students have an idea about which Questions 2023 will Prepare for the 11th & 12th Class Examination 2023.
ReplyDelete