SM/ADVISOR consume 13GB Space not able to cleanup from SYSAUX

Hello Team,

We have 50GB database out of which 16GB consumed by SYSAUX tablespace , while check occupant seen SM/ADVISOR consume 95% of space . we have tried to drop and create AUTO_STATS_ADVISOR_TASK with the help of Note: Doc ID 2692726.1 , which activity compete successful but space from sysaux not released.

steps performed below:

COL TASK_NAME FORMAT A35

SELECT TASK_NAME, COUNT(*) CNT FROM DBA_ADVISOR_OBJECTS GROUP BY TASK_NAME ORDER BY CNT DESC;

Drop of AUTO advisor:

DECLARE

v_tname VARCHAR2(32767);

BEGIN

v_tname := 'AUTO_STATS_ADVISOR_TASK';

DBMS_STATS.DROP_ADVISOR_TASK(v_tname);

END;

/

Then recreated: