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

MoidIITDocID-649: How to collect stats in Oracle?

Few examples:

exec dbms_stats.SET_GLOBAL_PREFS('AUTOSTATS_TARGET', 'AUTO');

exec dbms_stats.SET_DATABASE_PREFS('STALE_PERCENT', '15');

exec dbms_stats.GATHER_DATABASE_STATS(degree => 4, cascade => TRUE);

exec dbms_stats.GATHER_SCHEMA_STATS(ownname => 'SCOTT', degree => 4, cascade => TRUE);

exec dbms_stats.GATHER_TABLE_STATS(ownname => 'SCOTT', tabname => 'EMP', degree => 4, cascade => TRUE);

Click here for the link.

Moid 

MoidIITDocID-648: Data Guard in Pictures --Moid Muhammad

Click here for the document.

Moid Muhammad 

MoidIITDocID-647: Data Guard in Images

Click here for the document.

Moid Muhammad

MoidIITDocID-646: How to create 19c database using “create database” command? --Moid

Click here for the 19c document.

Moid