首页 > 数据库 >修改oracle11g的awr快照参数1、select * from v$version;

修改oracle11g的awr快照参数1、select * from v$version;

时间:2023-02-27 14:04:29浏览次数:54  
标签:control 00 快照 dba 30 awr version SQL select


1、select * from v$version;

修改oracle11g的awr快照参数1、select * from v$version;_oracle

 2、select * from dba_hist_wr_control;

检查当前系统的保留时间为8天,1小时采样一次.

修改oracle11g的awr快照参数1、select * from v$version;_oracle_02

3、这里设置每半个小时收集一次, 收集到的数据保留15天,单位都是秒。

exec dbms_workload_repository.modify_snapshot_settings(retention=> 21600, interval=> 30);

SQL> exec dbms_workload_repository.modify_snapshot_settings(retention=> 21600, interval=> 30);

PL/SQL procedure successfully completed.

SQL>  select * from dba_hist_wr_control;

      DBID
----------
SNAP_INTERVAL
---------------------------------------------------------------------------
RETENTION
---------------------------------------------------------------------------
TOPNSQL
----------
 922814785
+00000 00:30:00.0
+00015 00:00:00.0
DEFAULT

SQL> 
 

修改oracle11g的awr快照参数1、select * from v$version;_表空间_03

 后续要看实际效果如何,否则这个sysaux表空间一直在增加。

标签:control,00,快照,dba,30,awr,version,SQL,select
From: https://blog.51cto.com/u_15070324/6088392

相关文章