看到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 / SYSA[……]

查看全文