Script:以下脚本可以用于诊断SYSAUX表空间使用情况
./opatch lsinventory -detail @?/rdbms/admin/awrinfo select dbms_stats.get_stats_history_retention from dual; select dbms_stats.get_stats_history_availability from dual; select min(SAVTIME), max(SAVTIME) from WRI$_OPTSTAT_TAB_HISTORY; select min(SAVTIME), max(SAVTIME) from sys.wri$_optstat_ind_history; select min(SAVTIME), max(SAVTIME) from sys.wri$_optstat_histhead_history; select min(SAVTIME), max(SAVTIME) from sys.wri$_optstat_histgrm_history; select min(SAVTIME), max(SAVTIME) from sys.wri$_optstat_aux_history; select count(*) from sys.wri$_optstat_tab_history; select count(*) from sys.wri$_optstat_ind_history; select count(*) from sys.wri$_optstat_histhead_history; select count(*) from sys.wri$_optstat_histgrm_history; select count(*) from sys.wri$_optstat_aux_history; select count(*) from sys.wri$_optstat_opr;示例输出:
Snapshot interval is 60 minutes and Retention is 8 days
本文转自maclean_007 51CTO博客,原文链接:
http://blog.51cto.com/maclean/1278329