SYMPTOMS The SYSAUX tablespace uses too much space on the disk. — SYSAUX occupation by segment types SELECT SEGMENT_TYPE, ROUND(SUM(BYTES)/1024/1024) MB FROM DBA_SEGMENTS WHERE TABLESPACE_NAME = ‘SYSAUX’ GROUP BY SEGMENT_TYPE ORDER BY 2; SEGMENT_TYPE MB ——————– ———- TABLE SUBPARTITION 2 NESTED TABLE 2 LOB PARTITION…