AWR oracle

SELECT dbid, baseline_name, baseline_type, moving_window_size from dba_hist_baseline; 

      DBID BASELINE_NAME    BASELINE_TYPE MOVING_WINDOW_SIZE

---------- ---------------------------------------------------------------- ------------- ------------------

 536511065 SYSTEM_MOVING_WINDOW    MOVING_WINDOW   8

begin

dbms_workload_repository.modify_snapshot_settings(interval=>60,retention=>90*24*60);

end;

col RETENTION for a20

select * from dba_hist_wr_control;

      DBID SNAP_INTERVAL       RETENTION    TOPNSQL

---------- --------------------------------------------------------------------------- -------------------- ----------

 536511065 +00000 01:00:00.0       +00090 00:00:00.0    DEFAULT

select snap_id,

       to_char(begin_interval_time, ‘YYYY-MM-DD‘),

       to_char(end_interval_time, ‘YYYY-MM-DD‘)

  from dba_hist_snapshot

 order by snap_id;

手动生成AWR：

exec dbms_workload_repository.create_snapshot();