AUDSYS filling up Sysaux tablespace
Dear Team,
We are using Oracle 12R2 RAC with ASM on RedHat 7.4. We noticed about 2 months ago that the SysAux.
Further investigation reveals that the AUDSYS was taking most of the space
SELECT occupant_name "Item", space_usage_kbytes/1048576 "Space Used (GB)", schema_name "Schema", move_procedure "Move Procedure" FROM v$sysaux_occupants ORDER BY 2 desc; Item Space Used (GB) Schema Move Procedure---------------------------------------- --------------- ---------------------------------------- ----------------------------------------------------------------AUDSYS 133.85376 AUDSYSSM/OPTSTAT .988830566 SYSSM/OTHER .387207031 SYSJOB_SCHEDULER .14666748 SYSSM/ADVISOR .090026855 SYSSDO .075439453 MDSYS MDSYS.MOVE_SDOXDB .059387207 XDB XDB.DBMS_XDB_ADMIN.MOVEXDB_TABLESPACEXSOQHIST .037719727 SYS DBMS_XSOQ.OlapiMoveProcAO .037719727 SYS DBMS_AW.MOVE_AWMETASMON_SCN_TIME .028564453 SYSORDIM/ORDDATA .015869141 ORDDATA ordsys.ord_admin.move_ordim_tblspcWM .006347656 WMSYS DBMS_WM.move_procTEXT .002868652 CTXSYS DRI_MOVE_CTXSYSAUDIT_TABLES .001037598 SYS DBMS_AUDIT_MGMT.move_dbaudit_tablesSQL_MANAGEMENT_BASE .000854492 SYSPL/SCOPE .000793457 SYSSM/AWR .000549316 SYSORDIM .000427246 ORDSYS ordsys.ord_admin.move_ordim_tblspcAUTO_TASK .000305176 SYSEM_MONITORING_USER .000183105 DBSNMPLOGSTDBY .00012207 SYSTEM SYS.DBMS_LOGSTDBY.SET_TABLESPACESTREAMS .000061035 SYSEM 0 SYSMAN emd_maintenance.move_em_tblspcSTATSPACK 0 PERFSTATULTRASEARCH 0 WKSYS MOVE_WKULTRASEARCH_DEMO_USER 0 WK_TEST MOVE_WKORDIM/ORDPLUGINS 0 ORDPLUGINS ordsys.ord_admin.move_ordim_tblspcXSAMD 0 OLAPSYS DBMS_AMD.Move_OLAP_CatalogTSM 0 TSMSYSLOGMNR 0 SYSTEM SYS.DBMS_LOGMNR_D.SET_TABLESPACEORDIM/SI_INFORMTN_SCHEMA 0 SI_INFORMTN_SCHEMA ordsys.ord_admin.move_ordim_tblspcEXPRESSION_FILTER 0 EXFSYS32 rows selected.
0