SQL_MANAGEMENT_BASE does not release space
DB - 11.2.0.3.0 EE
OS - Linux
The SQL_MANAGEMENT_BASE occupant of SYSAUX tablespace has consumed more than 50% of sysaux. The size of sysaux is 4800MB. The parameter optimizer_capture_sql_plan_baselines is set to FALSE. When I query dba_sql_plan_baselines, it returns no records.
I have followed the steps from (Doc ID 1499542.1) but space used by SQL_MANAGEMENT_BASE remained the same. Even there are no segments for SMB, which shows it consumes more space.
SQL> select space_usage_kbytes from v$sysaux_occupants where occupant_name = 'SQL_MANAGEMENT_BASE';
SPACE_USAGE_KBYTES
------------------
2081024
SQL> SQL> select sum(space_usage_kbytes) from v$sysaux_occupants;