Cleanup SYSAUX using Doc ID 2305512.1

Hello,

Oracle 12.2 APR2020 SE.

I faced again issue with SYSAUX growth.

OCCUPANT_NAME

OCCUPANT_DESC

SPACE_MB

SCHEMA

------------------------------ ------------------------------------------------------- ------------ ------------------------------

SM/ADVISOR	Server Manageability - Advisor Framework	11,369.19  SYS
SM/OPTSTAT	Server Manageability - Optimizer Statistics History	2,236.69  SYS

I used mentioned ID Doc to clean up space used by Advisor: (Manual cleanup to avoid large undo)

SM/ADVISOR                     Server Manageability - Advisor Framework                       7.44  SYS

I assume that to clean up OPTSTATS I need to drop additionally:

SQL> DECLARE
v_tname VARCHAR2(32767);
BEGIN
v_tname := 'INDIVIDUAL_STATS_ADVISOR_TASK';
DBMS_STATS.DROP_ADVISOR_TASK(v_tname);
END;
/

And afterwords re-create both using: