sysaux 清理

 

select segment_name,segment_type,sum(bytes/1024/1024) M from dba_segments where tablespace_name = 'SYSAUX' group by segment_name,segment_type order by M desc

select segment_name,PARTITION_NAME,segment_type,bytes/1024/1024 from dba_segments where tablespace_name='SYSAUX' and segment_name='WRH$_ACTIVE_SESSION_HISTORY' order by 3;

WRH$_ACTIVE_SESSION_HISTORY_PK
WRH$_ACTIVE_SESSION_HISTORY

alter table sys.wrh$_active_session_history truncate partition WRH$_ACTIVE_1519739675_0 update global indexes;
alter session set ""_swrf_test_action"" = 72; --让系统对表进行分区

--alter table WRH$_ACTIVE_SESSION_HISTORY shrink space compact;
--analyze table WRH$_ACTIVE_SESSION_HISTORY compute statistics for table;
--alter table WRH$_ACTIVE_1519739675_0 shrink space;
--analyze table WRH$_ACTIVE_SESSION_HISTORY compute statistics for table;
select table_name,blocks, num_rows from user_tables where table_name=upper('WRH$_ACTIVE_1519739675_0');

select segment_name,PARTITION_NAME,segment_type,bytes/1024/1024 from dba_segments where tablespace_name='SYSAUX' and segment_name='WRH$_ACTIVE_SESSION_HISTORY' order by 3;