日期: 2015-02-05

重建AWR Repository

由于某个生产库上面awr的信息没有清理掉,导致sysaux表空间占用非常多

于是有了下面这个重建AWR的操作了

1、备份数据库、备份spfile

2、修改spfile的参数,停止awr统计信息的收集

alter system set shared_pool_size = 200m scope = spfile;
alter system set db_cache_size = 300m scope = spfile;
alter system set java_pool_size = 100 scope = spfile;
alter system set large_pool_size = 50 scope = spfile;
alter system set sga_target=0 scope= spfile;
alter system set memory_target=0 scope= spfile;
alter system set statistics_level=basic scope=spfile;

3、关闭数据库并启动到restrict模式
sqlplus /nolog
connect / as sysdba
shutdown immediate
startup restrict

阅读详细 »