SNAP_INTERVAL RETENTION
---------------------------------------
+00000 01:00:00.0 +00008 00:00:00.0
可以通过执行如下的 SQL 语句来修改自动生成 AWR 快照的时间间隔:EXEC
DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(INTERVAL => 30);
####修改快照设置
SQL> execute dbms_workload_repository.modify_snapshot_settings(interval =>
10, retention => 43200);
######强制生成快照
SQL> exec dbms_workload_repository.create_snapshot;
####相关视图:DBA_HIST_SNAPSHOT 并查看生成的快照
QL> desc DBA_HIST_SNAPSHOT;
Name Null? Type
----------------------------------------- -------- -----------------------
-----
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
STARTUP_TIME NOT NULL TIMESTAMP(3)
BEGIN_INTERVAL_TIME NOT NULL TIMESTAMP(3)
END_INTERVAL_TIME NOT NULL TIMESTAMP(3)
FLUSH_ELAPSED INTERVAL DAY(5) TO SECOND(1)
SNAP_LEVEL NUMBER
ERROR_COUNT NUMBER
SNAP_FLAG NUMBER
SNAP_TIMEZONE INTERVAL DAY(0) TO SECOND(0)
SQL> select SNAP_ID,DBID, CON_ID from DBA_HIST_SNAPSHOT order by SNAP_ID;
SNAP_ID DBID CON_ID
---------- ---------- ----------
20 1575700786 0
21 1575700786 0