AUTO_STATS_ADVISOR_TASK Not Purging in PDB after applying DBRU 19.29
Hi everyone,
We had the problem that the SYSAUX tablespace in PDBs was filling up with data from the AUTO_STATS_ADVISORY_TASK.
We are aware that there is a bug here with PDBs (MOS Note Doc ID 3104754.1).
This bug should have been fixed with DBRU 19.29.
However, this is not the case. I did the following in the PDB.
SQL> exec DBMS_Advisor.Set_Task_Parameter(‘AUTO_STATS_ADVISOR_TASK’, ‘EXECUTION_DAYS_TO_EXPIRE’, 10);
SQL> exec DBMS_Advisor.Set_Task_Parameter(‘INDIVIDUAL_STATS_ADVISOR_TASK’,'EXECUTION_DAYS_TO_EXPIRE', 10);
SQL> exec prvt_advisor.delete_expired_tasks;
Nothing was deleted.
How can I solve this problem? Is there a patch for version 19.29?