看到SYSAUX表空间涨的很快,
主要是以下表
- wri$_optstat_tab_history
- wri$_optstat_ind_history
- wri$_optstat_histhead_history
- wri$_optstat_histgrm_history
经查是bug
Document 10279045.8 Slow Statistics purging (SYSAUX grows)
Document 8553944.8 SYSAUX tablespace grows
Document 14373728.8 Bug 14373728 – Old statistics not purged from SYSAUX tablespace
Document 11869207.8 Improvements to archived statistics purging / SYSAUX tablespace grows
解决如下:
1.
begin
for i in reverse 10..100
loop
dbms_stats.purge_stats(sysdate-i);
end loop;
end;
/
2.
exec DBMS_STATS.PURGE_STATS(DBMS_STATS.PURGE_ALL)