sysaux tablespace freespace
Hi Experts,
We are on 12.1.0.2
We have purged sysaux stats using
SQL> EXEC DBMS_STATS.PURGE_STATS(DBMS_STATS.PURGE_ALL);
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
But still OPSTAT shows 75GB as before.Do we need to perform reorg here.Any steps you can provide?
Item Space Used (GB) Schema Move Procedure
------------------------- --------------- ------------------------- ----------------------------------------
AO .05 SYS DBMS_AW.MOVE_AWMETA
AUDIT_TABLES .00 SYS DBMS_AUDIT_MGMT.move_dbaudit_tables
AUDSYS .00 AUDSYS
AUTO_TASK .00 SYS
EM .00 SYSMAN emd_maintenance.move_em_tblspc
EM_MONITORING_USER .00 DBSNMP
EXPRESSION_FILTER .00 EXFSYS
JOB_SCHEDULER .02 SYS
LOGMNR .02 SYSTEM SYS.DBMS_LOGMNR_D.SET_TABLESPACE