查询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.