AWR 學習－－留一個筆記

SQL> col retention for a30
SQL>  col snap_interval for a30;

SQL> select * from dba_hist_wr_control;

      DBID SNAP_INTERVAL                  RETENTION                      TOPNSQL
---------- ------------------------------ ------------------------------ ----------
2342404700 +00000 01:00:00.0              +00007 00:00:00.0              DEFAULT

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

PL/SQL procedure successfully completed.

SQL>  col  snap_interval for a30;
SQL> select * from dba_hist_wr_control;

      DBID SNAP_INTERVAL                  RETENTION                      TOPNSQL
---------- ------------------------------ ------------------------------ ----------
1636893315 +00000 00:30:00.0              +00007 00:00:00.0              DEFAULT

 

手工生成快照：

SQL>exec dbms_workload_repository.create_snapshot;

生成AWR報表：

SQL> @?/rdbms/admin/awrrpt.sql