Database Administration (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center