DBMS_STATS Fails ORA-06512 and ORA-20001: exception in perform_cleanups: -24010: ORA-24010 (Doc ID 2660765.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• DBMS_STATS fails with ORA-06512:
  
  begin
  dbms_stats.gather_schema_stats(ownname => 'xx',options => 'GATHER AUTO');
  END;

  ORA-06512: em "SYS.DBMS_STATS", line 25671
  ORA-06512: em "SYS.DBMS_STATS", line 25742
  ORA-06512: em "SYS.DBMS_STATS", line 25694
  ORA-06512: em line 2
  From trace xxxx_ora_xxx_xxxx.trc
  --- back trace ---
  ORA-06512: em "SYS.DBMS_SYS_ERROR", line 86
  ORA-06512: em "SYS.DBMS_AQADM_SYS", line 7598
  ORA-06512: em "SYS.DBMS_AQADM", line 441
  ORA-06512: em "SYS.DBMS_STATS", line 2878
  DBMS_STATS: (Exception in gather table stats aux... cleaned: FALSE isTopLevel: TRUE)
  ORA-20001: exception in perform_cleanups: -24010: ORA-24010: QUEUE SYS.SCHEDULER$_EVENT_QUEUE não existe
  ----- PL/SQL Call Stack -----
  object line object
  handle number name
  0x3e7522948 493 package body SYS.DBMS_STATS_INTERNAL
  0x3eb796a70 2186 package body SYS.DBMS_STATS
  0x3eb796a70 24518 package body SYS.DBMS_STATS
  0x3eb796a70 24629 package body SYS.DBMS_STATS
  0x3eba3eea8 2 anonymous block
  --- back trace ---
  ORA-06512: em "SYS.DBMS_STATS", line 3017
  ORA-06512: em "SYS.DBMS_STATS", line 24483
  DBMS_STATS: (FORCED Exit: gather table stats aux)
  ORA-20001: exception in perform_cleanups: -24010: ORA-24010: QUEUE SYS.SCHEDULER$_EVENT_QUEUE não existe

   

Cause