看到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)

 

 

 

原创文章,转载请注明: 转载自ORADBCA

本文链接地址: 清空Statistics History

36.3K