A note on how to fix SYSAUX Block Corruption
Identify Objects in SYSAUX Tablespace set linesize 120 set pagesize 100 COLUMN "Item" FORMAT A25 COLUMN "Space Used (GB)" FORMAT 999.99 COLUMN "Schema" FORMAT A25 COLUMN "Move Procedure" FORMAT A40 SELECT occupant_name "Item", space_usage_kbytes/1048576 "Space Used (GB)", schema_name "Schema", move_procedure "Move Procedure" FROM v$sysaux_occupants ORDER BY 1; Item Space Used (GB) Schema Move Procedure ------------------------- --------------- ------------------------- ---------------------------------------- AO .00 SYS DBMS_AW.MOVE_AWMETA EM .08 SYSMAN emd_maintenance.move_em_tblspc EM_MONITORING_USER .00 DBSNMP EXPRESSION_FILTER .00 EXFSYS JOB_SCHEDULER .00 SYS LOGMNR