查询AWR保存策略与创建的快照

--查询AWR保存策略
SYS@PROD1> select * from dba_hist_wr_control;

      DBID SNAP_INTERVAL	RETENTION	     TOPNSQL
---------- -------------------- -------------------- ----------
2133791648 +00000 01:00:00.0	+00008 00:00:00.0    DEFAULT

--查询快照
SYS@PROD1> select distinct snap_id from sys.wrh$_active_session_history;

   SNAP_ID
----------
       498
       504
       494
       518
       522
       497
       500
       502
       523
       495
       496
       499
       505
       509
       510
       521
       516
       519
       507
       508
       512
       513
       514
       503
       511
       517
       520
       501
       515
       524

30 rows selected.

SYS@PROD1> exec dbms_workload_repository.create_snapshot;

PL/SQL procedure successfully completed.

SYS@PROD1> select distinct snap_id from sys.wrh$_active_session_history;

   SNAP_ID
----------
       498
       504
       494
       518
       522
       497
       500
       502
       523
       495
       496
       499
       505
       509
       510
       521
       516
       519
       507
       508
       512
       513
       514
       525
       503
       511
       517
       520
       501
       515
       524

31 rows selected.