Auto Optimizer Stats Collection Is Disabled and Yet Still Runs During Maintenance Window (Doc ID 2652183.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• The auto optimizer stats collection is disabled and yet still runs during maintenance window
• Alert Log show the following errors:
  ORA-20000: SYS_P1234 invalid partition name
  ORA-06512: at "SYS.DBMS_STATS", line 39142
  ORA-06512: at "SYS.DBMS_STATS", line 38699
  ORA-06512: at "SYS.DBMS_STATS", line 38422
  ORA-06512: at "SYS.DBMS_STATS", line 9288
  ORA-06512: at "SYS.DBMS_STATS", line 37749
  ORA-06512: at "SYS.DBMS_STATS", line 38683
  ORA-06512: at "SYS.DBMS_STATS", line 39116
  ORA-06512: at line 1
   
• The auto optimizer stats AUTO TASK "DISABLED":
  sys_SQLPLUS> SELECT client_name,status FROM Dba_Autotask_Client;

  CLIENT_NAME STATUS
  ----------------------------------- --------
  sql tuning advisor ENABLED
  auto optimizer stats collection DISABLED <<---
  auto space advisor DISABLED

   
  
• Why is this running?

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.