清理sysaux
-- sysaux
SELECT occupant_name, schema_name,(space_usage_kbytes/1024) M FROM v$sysaux_occupants ORDER BY 3;
select SNAP_ID,BEGIN_INTERVAL_TIME from dba_hist_snapshot order by 2;
exec dbms_workload_repository.drop_snapshot_range(low_snap_id =>95,high_snap_id => 96);
select min(SNAP_ID), max(SNAP_ID) from dba_hist_snapshot;
exec dbms_workload_repository.DROP_SNAPSHOT_RANGE(LOW_SNAP_ID=>XXXXXX,HIGH_SNAP_ID=>XXXXXX);
alter tablespace SYSAUX add datafile '+DATADG' size 16g autoextend off;