Monday, October 13, 2025

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')
);


No comments:

Post a Comment

Followers