1.查看当前的awr保存策略：
select * from dba_hist_wr_control ;
2.执行awr：
SQL> @?/rdbms/admin/awrrpt.sql
3.查看历史awr记录
select snap_id,dbid,startup_time,begin_interval_time,end_interval_time from dba_hist_snapshot ;
4.创建一个snapshot：
SQL> exec dbms_workload_repository.create_snapshot() ;
5.删除范围内的snapshot：
exec dbms_workload_repository.drop_snapshot_range(low_snap_id=>205,high_snap_id=>208,dbid=>3722795346) ;
6.Enabling the Automatic Workload Repository
SQL> show parameter statistics_level ;
7.Modifying Snapshot Settings Using the Command-Line Interface
7.1 The INTERVAL setting affects how often the database automatically generates snapshots.
7.2 The RETENTION setting affects how long the database stores snapshots in AWR.
7.3 The TOPNSQL setting affects the number of Top SQL to flush for each SQL criteria (Elapsed Time, CPU Time, Parse Calls, sharable Memory, and Version Count).
SQL> exec dbms_workload_repository.modify_snapshot_settings(retention=>43200, interval=>30,topnsql=>100, dbid=>3722795346);
8.修改采样时间间隔:
SQL> exec dbms_workload_repository.modify_snapshot_settings(interval=>120) ;

创建基线

SQL>exec dbms_workload_repository.create_baseline(start_snap_id=>3890,end_snap_id=>3899,baseline_name=>'BaseLine01') ;

删除基线

SQL>exec dbms_workload_repository.drop_baseline(baseline_name=>'BaseLine01',cascade=>true) ;

查询创建的基线

select * from dba_hist_baseline ;

--创建一个基线模板

--删除一个基线模板

ITPub博客

awr的命令