Yearly Archives: 2017

清空Statistics History

0

Posted on by

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

查看全文

关闭TFA工具

0

Posted on by

在检查数据库的时候看到cpu负载比较高,原来是tfa check的时候占用的cpu比较多,因非核心系统,决定关闭掉。

用root执行。

	--检查状态

	/u01/app/11.2/grid/bin/tfactl status

	--自启动关闭

	/u01/app/11.2/grid/bin/tfactl disable

	--关闭tfa

	/u01/app/11.2/grid/bin/tfactl stop