1.查询当前的设置
SQL> select * from dba_hist_wr_control;
DBID
----------
SNAP_INTERVAL
---------------------------------------------------------------------------
RETENTION
---------------------------------------------------------------------------
TOPNSQL
----------
1448896496
+00000 01:00:00.0
+00008 00:00:00.0
DEFAULT
字段snap_interval表示时间间隔,这里为每1小时收集一次AWR.
2.查看moving_window_size的大小
2.1.关于awr报告中的基准线(baseline)
A baseline is created with the CREATE_BASELINE procedure, A baseline is simply performance data for
a set of snapshots that is preserved and used for comparisons with other similar workload periods when
performance problems occur. You can review the existing snapshots in the DBA_HIST_SNAPSHOT view to
determine the range of snapshots that you want to use.
即baseline使用dbms_workload_repository.create_baseline存储过程创建,