MoidIITDocID-651: Check for resource limits between two times? --Moid Muhammad

SELECT * FROM dba_hist_resource_limit  WHERE snap_id IN 
( 
 SELECT snap_id FROM dba_hist_snapshot 
 WHERE begin_interval_time BETWEEN 
 TO_DATE('2025-10-13 07:45:00', 'YYYY-MM-DD HH24:MI:SS') 
 AND 
TO_DATE('2025-10-13 08:15:00', 'YYYY-MM-DD HH24:MI:SS')
);

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