SYSAUX Cleanup

Oracle 12.2.0.1

 32876409 APPLY          SUCCESS                  OJVM RELEASE UPDATE 12.2.0.1.210720

 32916808 APPLY          SUCCESS                  DATABASE JUL 2021 RELEASE UPDATE 12.2.0.1.210720

I faced issue discribed in: How To Purge Optimizer Statistics Advisor Old Records From 12.2 Onwards (Doc ID 2660128.1)

SYS@orcl> @scripts/tbs_info_PDB.sql

Tablespace       Tbsp %                                                    Allocated   Current   Current File %

Name               Free Filename                                                  GB   Used GB   Free GB  Free

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

SYSAUX              4.7 /u01/app/oracle/oradata/orcl/orclpdb/sysaux01.dbf     32.000    30.499     1.501   4.7

SYS@orcl> @scripts/sysaux_usage.sql

OCCUPANT_NAME                 OCCUPANT_DESC                                          SPACE_MB    SCHEMA

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

SM/ADVISOR                    Server Manageability - Advisor Framework                 28,059.94 SYS

SYS@orcl> @scripts/auto_stats_parameter.sql

TASK_NAME                PARAMETER_NAME                     PARAMETER_VALUE