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

ITPub博客

AWR 学习－－留一个笔记

最新文章