MoidIITDocID-650: How to force a snapshot to get flused for AWR report? --Moid

EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();

set linesize 200 pages 200
col BEGIN_INTERVAL_TIME format a35
col END_INTERVAL_TIME  format a35

select snap_id instance_number,  BEGIN_INTERVAL_TIME, END_INTERVAL_TIME
from dba_hist_snapshot
order by instance_number, BEGIN_INTERVAL_TIME;

Click here for the document.

Moid Muhammad