Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center